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