if you're using a with...

with sheets("Sheet1")

set rng = range(.cells(row,col),.cells(row,col)

end with


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=566385