How do I select last cell in column plus 1?

[limshady411]

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:

Please Login or Register  to view this content.

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

Thanks!

[K Dales]

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
>
>

[limshady411]

Thanks! This did the trick!

[Gary Keramidas]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>