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

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

How do I select last cell in column plus 1?
 

Thanks! This did the trick! :

--
limshady41
-----------------------------------------------------------------------
limshady411's Profile: http://www.excelforum.com/member.php...fo&userid=2871
View this thread: http://www.excelforum.com/showthread.php?threadid=48399

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