"Move to bottom of range"
ActiveCell.SpecialCells(xlLastCell).Offset(1,0).Se lect
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?
|