Thread: Last cell and first emty???!!!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnDK[_8_] JohnDK[_8_] is offline
external usenet poster
  
Posts: 1
Default Last cell and first emty???!!!

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 t
paste over data in the lastrow, it should be the first cell, next ro
down.

Any ideas?
Th

--
JohnD
-----------------------------------------------------------------------
JohnDK's Profile: http://www.excelforum.com/member.php...nfo&userid=718
View this thread: http://www.excelforum.com/showthread.php?threadid=48346

Reply With QuoteReply With Quote