calculationstate

Charlie wrote:


> Are saying you want all sheet calculations to complete first, then the
> Worksheet_Change event to fire last? (But the calculations are firing it
> prematurely?) Yea? Nay?

Worksheet_change is fired by a user who changes something on a sheet.
Because calculation is set to manual I must recalculate sheet.

Calcualate can fire worksheet_change once again, but I exit it if target
is out of specific region. It can happen when calcuate change something
of that sheet. But it doesn't and I quit worksheet_change if this is out
of region I am interested in.


application.calculate doesn't wait.
so the rest of code doesn't make sense, because data is not updateed on
the rest of sheets.



>
> Or you may need to rewrite your logic to move or duplicate what it is you
> are doing in the Worksheet_Change sub to your main code.

The only thing which I can do is to remove the rest of code from
worksheet_change, put it as a separate procedure and add button to
worksheet. Now user can finish code manualy, but I don't want to do that.

It's like a circle: can't calculate without data, can't get data without
calculating. Sounds like it's time to re-examine the logic flow and design a
new method of solving the problem.

"Kris" wrote:

> Charlie wrote:
>
>
> > Are saying you want all sheet calculations to complete first, then the
> > Worksheet_Change event to fire last? (But the calculations are firing it
> > prematurely?) Yea? Nay?
>
> Worksheet_change is fired by a user who changes something on a sheet.
> Because calculation is set to manual I must recalculate sheet.
>
> Calcualate can fire worksheet_change once again, but I exit it if target
> is out of specific region. It can happen when calcuate change something
> of that sheet. But it doesn't and I quit worksheet_change if this is out
> of region I am interested in.
>
>
> application.calculate doesn't wait.
> so the rest of code doesn't make sense, because data is not updateed on
> the rest of sheets.
>
>
>
> >
> > Or you may need to rewrite your logic to move or duplicate what it is you
> > are doing in the Worksheet_Change sub to your main code.
>
> The only thing which I can do is to remove the rest of code from
> worksheet_change, put it as a separate procedure and add button to
> worksheet. Now user can finish code manualy, but I don't want to do that.
>
>

Charlie wrote:
> It's like a circle: can't calculate without data, can't get data without
> calculating. Sounds like it's time to re-examine the logic flow and design a
> new method of solving the problem.
>
It's not a circle. There is no loop there.
Summary sheet collect data from other sheets and other sheet doesn't
need any data from summary sheet to be calculated.