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/