Why is there an error at End If ?
Previously it was working fine to delete all the unwanted rows
Basically the wanted rows would be the first row of every line.
Any row without a content in column A will need to be deleted.
Error either found in
See attached for example
Worksheet "MAR11 (t2)" is the initial worksheet
and "MAR11 (t2) (results) " is the desired final result . Macro-Test.xls