Excel/VBA Range and Find

J

Jon Turner

How do I find all the rows in an Excel ss where
a specific column (column F) is not filled in (blank).

Many Thanks In Advance
 
D

Dick Kusleika

Jon

It kind of depends on what you want to do with them. You can apply an
autofilter and filter on blank rows, you can use an advanced filter to copy
the rows with blanks to another sheet, or you can loop through all the cells
in Col F and use the IsEmpty() function.
 
Top