I have a Workbook with multiple identical worksheets.
I need a VBA macro that will delete all blank rows in a specific range on all worksheets inside a Workbook
example:
range of data on all sheets - A10:D17
This range has some rows that are blank and some rows contain the data.
How to delete empty or blank rows in all worksheets in a single action?
please see attach, thanks advance
Bookmarks