The Address method has rowAbsolute and columnAbsolute arguments. For
example, to assign the activecell address to the variable c you would use:

c = Activecell.Address(rowAbsolute:=False, columnAbsolute:=False)

Stan Shoemaker
Palo Alto, CA

"augustus" wrote:

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