Hi John,

Try:

Selection.End(xlDown)(2).Select

---
Regards,
Norman



"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