Sub test()
MsgBox Selection.Address
MsgBox Selection.Address(True, False)
MsgBox Selection.Address(False, True)
MsgBox Selection.Address(False, False)
MsgBox Selection.Address(True, True, xlR1C1)
MsgBox Selection.Address(False, False, xlR1C1)
End Sub

HTH. Best wishes Harald

"augustus" skrev i melding
...
Hi,

Is there way to reture the address of a cell without an absolute
reference?

Ie, I want address in A4:B7 format, and not in $A$4:$B%7 format.

I'm using Office2003