Thank Tom for your great help.

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

And I found how I change the for-loop loops from 'last-to-first' o
'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