Selection.End(xlDown).offset(1,0).Select

or

Selection.End(xlDown)(2).Select

--
Regards,
Tom Ogilvy


"JohnDK" wrote in
message ...

I can get the last cell in a range by code below.

Selection.End(xlDown).Select

However, i want the next cell down to paste a selection, i dont want to
paste over data in the lastrow, it should be the first cell, next row
down.

Any ideas?
Thx


--
JohnDK
------------------------------------------------------------------------
JohnDK's Profile:
http://www.excelforum.com/member.php...fo&userid=7184
View this thread: http://www.excelforum.com/showthread...hreadid=483469