HOW TO: Get cell address from a range
 

Kevin,

The address property takes 4 properties, RowAbsolute, COlumnAbsolute,
ReferenceStyle and RelativeTo. The first two goveren the absolute/relative
format and both default to True(that is, absolute). So to get a fully
relative address simply use

rgeMyCell.Address(False,False)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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