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