I have the following macro that deletes any hidden rows and columns from a worksheet. It works fantastic; however, I have to execute it individually for each sheet in a multi-sheet workbook.
Is there a line(s) that I could add to this macro to force it to execute on all sheets in a workbook automatically?
For lp = 256 To 1 Step -1 'loop through all columns
If Columns(lp).EntireColumn.Hidden = True Then Columns(lp).EntireColumn.Delete Else
For lp = 65536 To 1 Step -1 'loop through all rows
If Rows(lp).EntireRow.Hidden = True Then Rows(lp).EntireRow.Delete Else