Hi, I’m new here. I figure I’d get that out of the way right away. I’m also relatively new to the concept of implementing VB into my excel worksheets. I maybe a bit more than a novice but not by much.
So my issue what I’m trying to attempt, is I have a worksheet with multiple drop down choices, and based on those choices I have named ranges that hide whole rows.
What I’m looking to do, is have a way that at any given moment, I code run a piece of code that would tell me exactly what sections, or more precisely what named ranges within my sheet are currently being hidden and display that information in the form of a msgbox.
Like Range_blah blah is hidden.
If anyone can help me out I’d appreciate it.