View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Copacetic Copacetic is offline
external usenet poster
 
Posts: 17
Default "Move to bottom of range"


Right on the money. Thanks.

On Sun, 18 Apr 2010 02:24:34 -0700 (PDT), Per Jessen
wrote:

ActiveCell.SpecialCells(xlLastCell).Offset(1,0).S elect

Or like this:

Range("A1").End(xlDown).Offset(1,0).Select

Regards,
Per

On 18 Apr., 10:23, Copacetic
wrote:
Hello,

*I have some code that adds the contents of one sheet to the end of
another. How do I correctly select the first empty cell below the first
sheet that I want to add data to?

* Something like

* * ActiveCell.SpecialCells(xlLastCell).Select

'Move to bottom of range

* ^^^ This is where I need work.

* Can I simply perform a cursor key move down one cell?

* How do I code cursor key operations?