Thread: How do I select last cell in column plus 1?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
  
Posts: 1,163
Default How do I select last cell in column plus 1?
Range("A65536").End(xlUp).Cells(2,1).Select
Just make sure when you do this you are not on Row 65536!!!
--
- K Dales


"limshady411" wrote:


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


Reply With QuoteReply With Quote