This is not a straightforward issue - and we generally get paid fo
writing code <<grin.

You are "starting from the wrong place". Generally it is best to star
the macro recorder and record your actions. This gets things started a
well as clarifying the method.

The method I suggest is :-
1. sort the data
2. find the first line to delete
3. delete the rows.

Having done this, the next job will be to change the code so it wil
work on any sheet, and then get it to delete the other items.

I suggest you make a new message for further problems because many o
us do not tend to read messages with replies already there

--
Message posted from http://www.ExcelForum.com