Need help code execute on all worksheet in workbook

[prdponce]

I found this code that looks for empty rows on the active worksheet and deletes the empty rows.

I have several worksheets in a workbook. They have some empty rows in areas that I wan to delete. I would like to be able to highlight / select the range and delete all the empty rows in the selection of all the worksheets.

Please Login or Register  to view this content.

Thanks for any help you can provide on this.

[davesexcel]

This should work, haven't tested it though,

Please Login or Register  to view this content.