Is there an object that represents a blank cell?

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?

Not that I know of, but others may know of something. Just add this after your for each statement

Please Login or Register  to view this content.

You may do this:

Please Login or Register  to view this content.