I am trying to select a range of rows, group them, then hide the details. I can do it by specifying the rows but would like to find a way to do it by my currently selected range.
Thanks in advance for any ideas!
I am trying to select a range of rows, group them, then hide the details. I can do it by specifying the rows but would like to find a way to do it by my currently selected range.
Thanks in advance for any ideas!
Hi jsnyder, welcome to the board!
Have you tried doing this while recording a marco (Tools | Macro | Record new macro)? That will give you the starting blocks you'll need. If you need more help after that, post the code you got from the macro recorder (Alt + F11).
HTH
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables