Hey Rick,

I didn't understand your post under "VBA mid() function" on 11/2/09. Did I
miss something?

"Rick Rothstein" wrote:

How many groupings do you have? Are you trying to get rid of them all? Does
this, perhaps, do what you want?

Selection.Rows.ClearOutline

--
Rick (MVP - Excel)


"CM4@FL" wrote in message
...
For example: Say I have a spreadsheet with 3 layers of row grouping.

Currently I'm using the following code to ungroup all 3 layers, which
works
for the this particular example.
Selection.Rows.Ungroup
Selection.Rows.Ungroup
Selection.Rows.Ungroup

Unfortunately the spreadsheet in question does not always have 3 layers of
grouping, it may have more it may have less. Which either cause the VBA to
error or not remove all the groupings. Is there any coding that will
remove
all groupings within a worksheet without reference to the # of layers?

Thanks in advance!



.