Question : excel vba address not absolute
Answered by : vastemonde
MsgBox Range("A1:B3").Address(RowAbsolute:=False, ColumnAbsolute:=False) ' A1:B3
MsgBox Range("A1:B3").Address(RowAbsolute:=True, ColumnAbsolute:=True) ' $A$1:$B$3
Source : | Last Update : Sun, 24 Jan 21