Yep, you're right.

I don't have a work around that overcomes manual calculation, but with
calculation set to automatic, you could add an =subtotal() formula somewhere
that depended on that range of rows that are grouped.



Dirk Flakowski wrote:

Hello Dave,

thanks for your answer, but that event only fires if
"Application.Calculation" is set to Automatic and if that grouping
contains cells that have to be recalculated.
So this is no solution for me.

Does anybody else maybe have an additional idea?

Thanks in advance,
Dirk

On Mon, 28 Nov 2005 12:07:31 -0600, Dave Peterson
wrote:

I'm not sure what notified means, but I think the worksheet_calculate event
fires if you're grouping rows--but not columns.

But lots of stuff causes that event to fire.

--

Dave Peterson

--

Dave Peterson