CODEWITHSUNDEEP
vbaexcel
SoftTimur
SoftTimur

Reputation: 5490

Trigger a full calculation in VBA

Given a workbook that contains lots of formulas, i realise that when its cell values are up-to-date, F9, ActiveWorkbook.Calculate or Sheets(1).calculate does not trigger a re-calculation.

However, if a cell value that is referenced by another cell through formula changes, F9, ActiveWorkbook.Calculate or Sheets(1).calculate will trigger a recalculation of all the formulas that depend on the changed cell.

In one word, Excel just recalculates which is necessary.

However, I would like to measure the behavior (eg, time) of a FULL calculation of the workbook (ie, refreshing from the constant values, then the formulas depending on them, then a higher level formulas...).

Does anyone know how to trigger such a full calculation in VBA?

Upvotes: 4

Views: 10804

Answers (1)

Rory
Rory

Reputation: 34045

You have two options - CalculateFull and CalculateFullRebuild. The latter will rebuild the entire dependency chain so may be overkill here. Note that both will apply to all open workbooks, not just the active one.

Upvotes: 6

Related Questions