Augustus

Try
rng.Address(RowAbsolute:=False, ColumnAbsolute:=False)

where rng is your range object.

--

Charles
www.officezealot.com



"augustus" wrote in message
...
Hi,

Is there way to reture the address of a cell without an absolute
reference?

Ie, I want address in A4:B7 format, and not in $A$4:$B%7 format.

I'm using Office2003