selecting all blanks in multiple columns, then deleting those rows
I have done this in just one column: selecting all the blanks and then using
Selection.EntireRow.Delete. Works fine.
I am now working with a dataset that is formatted just terribly, full of
headers and subtotals, and the best way to clean it up would be to highlight
the entire range (OK), select all the blanks (OK), and delete the rows (not
OK).
I get no error message, but Excel just skips that line of code and leaves
all the blanks highlighted as nice as you please. Just neglects to delete
them.
Is this because they are scattered in all different columns? When I stop the
macro and go to Excel itself, Edit/delete/row wipes out all the proper rows.
Just can't get it done programmatically, and I don't know why.
|