ActiveCell.Address to return non Absolute reference

P

PCLIVE

myAddress = ActiveCell.Address

This will return something like "$A$1".
Is there a way to have this return the non-absolute reference of "A1"
withoug having to use a worksheetfunction such as Substitute?

Thanks in advance.
Paul
 
J

JLGWhiz

Or:
myAddress = ActiveCell.Address(False, False)

Same thing as Mike's, except using the constant instead of the value.
 
G

Gary''s Student

Sub dural()
myAddress = ActiveCell.Address(rowabsolute:=False, columnabsolute:=False)
MsgBox (myAddress)
End Sub
 
P

PCLIVE

By the way, I went with the following method:

ActiveCell.Address(0, 0)

Thanks again.
 
Top