Control Order of Calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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
 
Back
Top