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

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