..address() has some parms that you can pass to it:

..address(rowabsolute:=false,columnabsolute:=false )
or
..address(rowabsolute:=0,columnabsolute:=0)
or
..address(0,0)

All do the same thing--they stop the corresponding $ signs from showing up in
the address:

$B$9
or
$B9
or
B$9
or
B9

(depending on which parms are true or false)



John wrote:

cool... what does the Address (0,0) mean?
John

Tom Ogilvy wrote:

try1 = Cells(i,j).Address(0,0)

Try1 will hold something like "B9"


--

Dave Peterson