Next Empty Column in Row

S

scain2004

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
 
S

scain2004

Figured it out.

Created a For loop that checked the row for the next empty column. Duh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top