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.

On Aug 9, 12:16 pm, 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.

Perhaps it's possible with VBA but what's the advantage to calculating
only certain cells at a time?

I am assuming that the time savings that occurs when a set of equations is
converted into an array is because within the array excel can do all the
equations sequentially instead of searching for interrelated dependencies (It
probabably goes through each column in row 1 then moves to row to etc.). So
without the array it may have to recalculate the sheet multiple times to
calculate through all the precedence in a sheet. What I want is to assign a
block that I know share the same precedence (like an array) and tell excel to
calculate all at once (sequentially) then move on to another. The reason for
this is time savings, like an array. I know I could probably assign each
cell a variable name in VBA and force it myself but I was hoping for a better
way.
Thanks,
Bryan H

"Dave F" wrote:

On Aug 9, 12:16 pm, 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.

Perhaps it's possible with VBA but what's the advantage to calculating
only certain cells at a time?

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

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