Deleting rows that have been Group'ed in VBA

Hello - Lets say you load up rows on a worksheet (from a table in a database), separating them by a given category into 3 separate sections, .Group those 3 sections, then .Outline and collapse those 3 sections.

(That's 3 separate single-level sections, not a 2-level hierarchy with 3 base-level sets)

Then you need to clear all this out to reload a different set of rows (the user wants to see rows from a different parent ID)

Do you have to .Ungroup each section before .Delete'ing the rows? (there are elements in & around these 3 sections, with named ranges, so I can't just clear the whole worksheet)

Who is Participating?
mlagrangeAuthor Commented:
Well, I resorted to Ungrouping each section, then coming back and deleting the rows

Thanks for your response
Elton PascuaCommented:
Would you consider a Pivot Table option?
mlagrangeAuthor Commented:
I stumbled upon the solution...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.