Hi,

Like this

r = Range("A1").Address(0, 0)

change to zeroes to 1's for different address types
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"B Subramanian Raman [Bala]" wrote:

I wish to know how to store the relative cell reference in a variable that
can be checked while designing a macro in MSOffice 2003.