That's why I used column A, since the sporadic blanks cells are in column F.

HTH,
Bernie
MS Excel MVP

Your code works from the top down and will stop at the 1st blank cell. The OP says that there are
sporadic blank cells...

Is it possible to find the bottom of a sheet, say there are 1500 entries in
column A... and then select F9:F1500 if column F doesn't have values in every
row?