cells(selection.end(xldown).row + 1, selection.column).select

"PaulSin " wrote in message
...
I can't remember how I did this last time.....
I've got a range of cells and I need to go to the last cell to paste in
a load of new data.
I can use Selection.End(xlDown) fine to get to the last cell, but then
I want to offset one cell down. The code I have for the offset is
Cell.Offset(1,0).Select, but this comes back with an error saying it
needs an object. Any ideas on what I'm doing wrong?
Thanks
Paul


---
Message posted from http://www.ExcelForum.com/