L
Legacy 96851
Guest
Almost made it through the day without asking anything. At least the questions are getting more trivial.
I have a macro that pretty much groups every 6 rows in a couple of worksheets. I want to be able to run the macro multiple times on the same workbook, but as you can imagine, I don't want the grouping to happen again. At the beginning of the code I have
This, however, doesn't ungroup anything.
Is there a way to A.) ungroup all grouped rows in the sheet or B.) check if a range/row is grouped, something like IsNumeric() but for groups.
Thanks in advance, because I'm sure someone will know!
I have a macro that pretty much groups every 6 rows in a couple of worksheets. I want to be able to run the macro multiple times on the same workbook, but as you can imagine, I don't want the grouping to happen again. At the beginning of the code I have
Code:
With .UsedRange
.ClearContents
.ClearFormats
.FormatConditions.Delete
.Ungroup
End With
Is there a way to A.) ungroup all grouped rows in the sheet or B.) check if a range/row is grouped, something like IsNumeric() but for groups.
Thanks in advance, because I'm sure someone will know!