Posted to microsoft.public.excel.misc
|
|
Control Order of Calculations
Thanks to both Dave's
Bryan H
"Dave Peterson" wrote:
Depends on the version of excel (IIRC).
Look in VBA's help for "Calculate Method"
You'll see that you can specify ranges to calculate.
You may want to read Charles Williams' notes on calculation:
http://www.decisionmodels.com/calcsecrets.htm
especially this page:
http://www.decisionmodels.com/calcsecretsg.htm
(look for: "Excel 2002/2003 Range Calculate Problems:")
BryanDamon wrote:
Is it possible to control the order that excel calculates a page? Similar to
an array, I would like to highlight a 3 different 'blocks' of equations and
then tell excel calculate 1 completely, then calculate 2, then calculate 3.
--
Dave Peterson
|