| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| order of calculations in Excel | Excel Worksheet Functions | |||
| Control X axis order | Charts and Charting in Excel | |||
| Calculations And Order In Macros | Excel Discussion (Misc queries) | |||
| Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) | |||
| Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Hybrid Mode
