The user has the below VBA works properly to hide/unhide rows 2:4
Supposedly the user named rows 2:4 to some Range Name, say Range Name “Magdoulin”
How could the user rewrite the code to hide/unhide this particular range name in this case?
The user intends to build a sheet which would have very dynamic rows interred from time to time and writing the code depending on numbering the rows themselves would be a disaster in this case.
Hope this will help
Obtained from the OzGrid Help Forum.
Solution provided by Carim.
|How to hide and unhide with checkboxes - multiple checkboxes do multiple different things|
|How to reference text in cell to unhide worksheet|
|How to unhide worksheets identified by specific cells in main sheet|
|How to hide/unhide rows|