ActiveCell.Address to return non Absolute reference

[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

 

[Mike H]

Hi,

maybe

myAddress = ActiveCell.Address(0, 0)

Mike

 

[JLGWhiz]

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

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

 

[Gary''s Student]

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

 

[PCLIVE]

Thanks everyone.
That's what I was looking for.

Paul

 

[PCLIVE]

By the way, I went with the following method:

ActiveCell.Address(0, 0)

Thanks again.