First Blank Column from L to R

[bs0d]

I'm looking for an effective way to identify the first blank column (working from left to right).

There could be columns of data with empty columns in between.

For instance:

has data: A, B, C, E, G

blank: D, F, H to End

 

[bs0d]

It was having issues, I might have been able to figure it out but in the interest of time, I had to move on. I might have tested using a select statement to make sure the desired tab was at focus.

But my workaround was to just keep incrementing the max column. For my project and number of entities, I would not be in a position to run out of columns - even though filling the blanks (essentially a left align) would have been more visually favorable.

 

[Rick Rothstein]

It was having issues, I might have been able to figure it out but in the interest of time, I had to move on. I might have tested using a select statement to make sure the desired tab was at focus.

But my workaround was to just keep incrementing the max column. For my project and number of entities, I would not be in a position to run out of columns - even though filling the blanks (essentially a left align) would have been more visually favorable.

I missed the original thread when it first appeared. The problem with SpecialCells is, with a couple of exceptions, it only "sees" the UsedRange for the sheet it is operating on.... if you have all the columns filled with at least one value out to the end of your data, the blank column to the right of the last used column falls outside of the UsedRange, so as far as SpecialCells is concerned, there is no blank to find. Now, as for the question of the column number of the first blank column, This should work...

ColumnNumberOfFirstBlankColumn = Range("A1").CurrentRegion.Columns.Count + 1