I want to use a For Each loop running straight down a column. But instead of doing For Each 'cell' where cell is a range object I would like Excel to evaluate only blank cells inside of the column.
For example, For Each blankCell in Range("G:G"), where the variable blankCell is an object that represents a blank cell.
Is there such thing as a blank cell object?
Bookmarks