I'm trying to improve a macro in an EXCEL spreadsheet. The spreadsheet has multiple tabs (sheets), some of which have grouped rows in them. My "cleanup" routine needs to check to see if these grouped rows exist. Is there some code that does this (hopefully boolean)?
If it helps, I'm using the following code to group:
Rows(begRow & ":" & endRow).Select Selection.Rows.Group
However I only want to ungroup these sheets if grouping exists on the page anywhere.
Thanks for your help.