Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Next Empty Column in Row
I'm trying to figure out how to find the next empty column in a row o
data. Range("DateRange").Cells(rowCntr, xlEnd) = jobType is what I have now. This is part of a loop so right now it finds th next empty column, but won't go past that in future increments of th loop. Doesn't xlEnd update as data's entered or do I have to fin another way to increment the columns -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Next Empty Column in Row
Figured it out.
Created a For loop that checked the row for the next empty column. Duh -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
only match if column is not empty | Excel Discussion (Misc queries) | |||
Select first empty row in a column | Excel Discussion (Misc queries) | |||
Looping until empty column | Excel Discussion (Misc queries) | |||
delete empty column in VBA | Excel Programming | |||
Finding last non-empty column in row... | Excel Programming |