Microsoft KB Archive/27530

{| = Excel: Calculating Only One Cell When Running Macro =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q27530

SUMMARY
When a command macro is run in Microsoft Excel, the cells on the worksheet recalculate. To recalculate only one cell when the macro runs, set calculation to Manual and enter the following code to calculate the desired cell:

=SELECT(reference) =FORMULA(GET.FORMULA(ACTIVE.CELL)) &quot;Reference&quot; refers to the cell to be recalculated. For example, if you want cell B3 on your worksheet to be recalculated by the macro, enter the following in your command macro: =SELECT(!B3) =FORMULA(GET.FORMULA(ACTIVE.CELL))
 * }