HOW TO: Get cell address from a range
 

Set the first two parameters of .Address to False:

rgeMyCell.Address(False, False)

--
Regards

Juan Pablo González

"Kevin McCartney" wrote in message
...
HI TWIMC,

If I set a range to the cell B1 I'd like to be able to a get the cell
address in the style of B1 not B$1$, so what code do I need to use instead
of:

rgeMyCell.Address


TIA
KM