All I can tell you is that as I posted it, that it did not delete truly
blank rows for me and as written, row C would be deleted and Row A retained.

--
Regards,
Tom Ogilvy

"kaon " wrote in message
...
Thank Tom for your great help.

No idea why the macro still keeps deleting truly blank rows! (Does the
border count?)

And I found how I change the for-loop loops from 'last-to-first' or
'first-to-last', it deletes duplicate rows with my data away.

Example:
A) Depre 123 123 124
B) Reven 123
C) Depre

I want to delete row C, but it keeps deleting row A!

What a mystery!


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