Did you mean to post that in reply to tehwa's note?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"mudraker " wrote in message
...
when you delete row 5 row 6 becomes the new row 5.
your macro has already checked row 5 so does not look at row 5 again
and moves onto row 6

when you go backwards when you delete row 5 and row 6 becomes the new
row 5 - you would have already checked the new row 5 when it was still
row 6, your macro then moves down to row 4


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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004