Since expanding and collapsing is not a recognized event this is a real up
hill battle. How about just applying a Format - AutoFormat to the subtotals.
That should help you get some physical deliniation between data and
subtotals...
--
HTH...

Jim Thomlinson


"Dallman Ross" wrote:

I have a sheet full of grouped rows with subtotal rows at the
bottom of each group/set. When all the groups are collapsed,
I see only the subtotal rows. When I expand a group, I have
a bit of trouble visually distinguishing that group's subtotal
row from others just below it. I would like to code some
sort of event code that changes that subtotal row's color if
the group is expanded. Is this possible within reason?
I'm using Excel 2002.

--
dman