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


Hello,

I am trying to select the last cell in a column plus one. Right now, I
can select the last cell in a column, but I want to select the next one
which is blank. Any ideas?

Here's the code I have:


Code:
--------------------
Range("A65536").End(xlUp).Select
--------------------


Now I just want to select the next cell...

Thanks!


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