View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PaulSin PaulSin is offline
external usenet poster
 
Posts: 1
Default Select last cell in range

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 i
a load of new data.
I can use Selection.End(xlDown) fine to get to the last cell, but the
I want to offset one cell down. The code I have for the offset i
Cell.Offset(1,0).Select, but this comes back with an error saying i
needs an object. Any ideas on what I'm doing wrong?
Thanks
Pau

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