ActiveSheet.UsedRange.Columns(3). _
SpecialCells(xlCellTypeBlanks).EntireRow.Delete
I have been using this for a while now to remove empty rows from crystal report that have been exported to excel. Today the report was altered so I needed to alter my code and now that above line deletes everything.
Anyideas?
