Hello,
I have approximately 40 worksheets which have a table with an identical format but contain varying data results.
In each worksheet I need to hide a specific set of rows, but the set of rows I would like to target could be one of four combinations. To start, is it possible to create a macro which will hide a specified set of rows (ie. Rows 17:31, Rows 42:61, Rows 67:86)? I should be able to edit the VBA for the new row sets, but don't know how to get that starting point.
Two additional related improvements to the code (wishlist):
Thank you in advance for your help!
N
I have approximately 40 worksheets which have a table with an identical format but contain varying data results.
In each worksheet I need to hide a specific set of rows, but the set of rows I would like to target could be one of four combinations. To start, is it possible to create a macro which will hide a specified set of rows (ie. Rows 17:31, Rows 42:61, Rows 67:86)? I should be able to edit the VBA for the new row sets, but don't know how to get that starting point.
Two additional related improvements to the code (wishlist):
- What changes can be made to this VBA for it to toggle the "hidden/unhidden" status of the selected rows?
- Using either a list on a seperate worksheet called "SSU Table Listing" or through a userform, can I specify multiple worksheets for the VBA to be applied to with the single run of the original macro?
Thank you in advance for your help!
N
