I don't know what is range.get_Address, but if your currently selected cell
is A1 then
selection.address(true,false)
returns A$1.

Regards,
Stefi

€žJsJ_Slim€� ezt Ã*rta:

Hi,
I'm using Application.InputBox(,,,,,8) in my Excel vsto AddIn to retrieve a
Range. However, I need help getting the exact reference text.

Eg, selecting a range, then hitting F4 to turn it to A$1 instead of $A$1.
I'm trying to get A$1, but the only way that I can think of to get the
address is via range.get_Address, which returns me $A$1 format instead of A$1.

Please help.

Thanks