Microsoft KB Archive/51062

From BetaArchive Wiki

Excel: Using External References to Make Macros Run Faster

Last reviewed: April 3, 1997
Article ID: Q51062

1.50 2.20 3.00 MACINTOSH kbother


To reference cells on other sheets in Microsoft Excel version 1.50 or later, use external references. Using external references is much more efficient than activating the desired sheet, selecting the appropriate cell, and then returning to the original sheet.

For example, the following macro selects cell R2C2 (B2) on Sheet2 by activating Sheet2 and then returning to Sheet1:


You can accomplish the same result much faster by using the following macro commands:



This information was taken from page 151 in the "Macro Tips" section of the "Microsoft Excel Technical Reference for the Macintosh."

The "Microsoft Excel Technical Reference for the Macintosh" can be obtained as part of the Excel Developer's Kit by calling Microsoft End User Sales and Service at (800) 426-9400.

KBCategory: kbother


Additional reference words: 1.50 2.20 3.00

Last reviewed: April 3, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.