Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding next Blank Cell in Column
Do until null
Range("a1").Offset(1, 0).Select Loop I am trying to find the next blank cell in a column to paste value into. I thought this simple loop would do it, but it gets stuck a this point. I am just beginning and would really appreciate your help Thanks -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding next Blank Cell in Column
Range("A1").Select
do while not isempty(activeCell) activeCell.offset(1,0).Select Loop or Range("A65536").End(xlup)(2).Select -- Regards, Tom Ogilvy "trickdos " wrote in message ... Do until null Range("a1").Offset(1, 0).Select Loop I am trying to find the next blank cell in a column to paste values into. I thought this simple loop would do it, but it gets stuck at this point. I am just beginning and would really appreciate your help. Thanks. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding next Blank Cell in Column
try incorporating this
x=range("a65536").end(xlup).row+1 -- Don Guillett SalesAid Software "trickdos " wrote in message ... Do until null Range("a1").Offset(1, 0).Select Loop I am trying to find the next blank cell in a column to paste values into. I thought this simple loop would do it, but it gets stuck at this point. I am just beginning and would really appreciate your help. Thanks. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Next Blank Cell in Blank Row | Excel Worksheet Functions | |||
Finding next non-blank cell | Excel Discussion (Misc queries) | |||
Finding the bottom non-blank cell in a range | Excel Discussion (Misc queries) | |||
Finding first blank in column | Excel Discussion (Misc queries) | |||
Finding first non-blank cell | Excel Programming |