Hi
Just put the offset bit directly after. eg
Selection.End(xlDown).Offset(1, 0).Select
-----Original 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/

.