• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

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)

Thanks
0
mlagrange
Asked:
mlagrange
  • 2
1 Solution
 
Elton PascuaCommented:
Would you consider a Pivot Table option?
0
 
mlagrangeAuthor Commented:
Well, I resorted to Ungrouping each section, then coming back and deleting the rows

Thanks for your response
0
 
mlagrangeAuthor Commented:
I stumbled upon the solution...
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now