Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Using a formula to select a cell using the row and column values | Excel Worksheet Functions | |||
select every other cell in a column | Excel Discussion (Misc queries) | |||
Select a column based on a cell entry | Excel Programming | |||
I want to select the first blank cell in column A | Excel Worksheet Functions |