Selecting rows of selected cells

[jdskin2]

Tried google search but have not found what I am looking for. I am trying to select the rows of all currently selected cells.

I have done the go to (f5) to highlight blank cells in a column, now I want to select all the rows with the blank cells in that column.

Have seen how to hide the rows, delete the selected cells, but cannot find how to select all rows of current selected cells.

Thanks,

[JieJenn]

You might need to use macro to do that

Look at the attached to see if that's what you're looking for.

[jdskin2]

I think that will work perfectly, have been using an extra column and IF formula to sort out the blanks but this will help me reduce that step.