I need a macro to run with a button.
If I have a range of say A1:T8
Rows 1 and 2 are heading rows and rows 3-8 have data. If row 3 is empty of data then rows 1-8 are hidden. If row 3 has data then check each row after it and hide rows with no data.
Then I need a simple macro for another button to unhide all hidden rows.
Thank you in advance for the help.![]()
Bookmarks