View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default How do I select last cell in column plus 1?

these both accomplish the same thing kd posted. just different ways

Range("A65536").End(xlUp).Offset(1, 0).Select

Range("A65536").End(xlUp).Range("a2").Select

--


Gary


"limshady411"
wrote in message
...

Thanks! This did the trick! :)


--
limshady411
------------------------------------------------------------------------
limshady411's Profile:
http://www.excelforum.com/member.php...o&userid=28711
View this thread: http://www.excelforum.com/showthread...hreadid=483995