Microsoft KB Archive/24871

Excel: Worksheet vs Macro Sheet Order of Calculation 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].

KBCategory: kbother KBSubcategory: Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 Last reviewed: October 31, 1994 © 1998 Microsoft Corporation. All rights reserved. Terms of Use.