Printable View
Is it possible with VBA to group rows that are not contiguous; i.e., based on some criteria within the row? I'd like to group, for example, rows 1, 2 and 4 and exclude row 3 from the grouping? After grouping, I'd like the user to be able to view certain group levels using the standard group level selection (1, 2, etc.)
Thanks.
you can try this using union to create a noncontiguous range then select the range
Thanks for suggestion. I've already done that, but was wondering if there was a way to group rows as you do in Excel and then are able to select different outlining levels. When you try to manually group non-contiguous rows, Excel won't allow it. I was hoping you could get around that with VBA.
i am not sure if you can define a named range from a noncontiguous range
That's okay. I've coded a replacement routine that should do the trick.