Looking to DELETE all ROWS in Entire workbook with 8 sheets.

[trekker1218]

Hello,
I need a way yo delete ALL empty rows in an entire workbook with 8 sheets.

I found a few here and they do not seem to work for more than one sheet.

Any help would be great!

Thanks in advance.

Tino

 

[MARK858]

Are your cells actually empty or formulas returning ""?
If they are actually blank then the usedrange will reset when you save & close the workbook.