Microsoft KB Archive/24871

{| = Excel: Worksheet vs Macro Sheet Order of Calculation =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q24871

SUMMARY
Worksheets calculate cells in random order, depending on which supporting values in the sheet have changed.

Macro sheets calculate only when they are executed, and macro cells calculate one after another down a single column [unless a GOTO, RETURN, HALT, or RUN command or a user-defined function is called].
 * }