vba absolute excell code example

Example: excel vba address not absolute

MsgBox Range("A1:B3").Address(RowAbsolute:=False, ColumnAbsolute:=False)    ' A1:B3
MsgBox Range("A1:B3").Address(RowAbsolute:=True, ColumnAbsolute:=True)      ' $A$1:$B$3