How calculate only Dirty cells on manual Calculate?

[onidarbe]

I used Application.Calculation = xlCalculationManual and want to calculate from in a function, without calculating everything.
Using Application.Calculate calculates everything !!!

So how can I only let the dirty cells and those cells that use them in there function be calculating?

thanks.

 

[JoeMo]

I used Application.Calculation = xlCalculationManual and want to calculate from in a function, without calculating everything.
Using Application.Calculate calculates everything !!!

So how can I only let the dirty cells and those cells that use them in there function be calculating?

thanks.

Create a named range of the cells you want to limit calculation to - say "DirtyCells".

Range("DirtyCells").Calculate

 

[shg]

I think Calculate only does calculate dirty cells and volatile formulas, equivalent to F9. Perhaps the latter is the problem.

CalculateFull and CalculateFullRebuild calculate everything.