Microsoft KB Archive/51067

Excel: SET.VALUE() Is Faster Than SET.NAME() and FORMULA() Last reviewed: April 3, 1997 Article ID: Q51067

2.20 3.00 MACINTOSH macrosheet kbother SUMMARY Using SET.VALUE() on a cell in Microsoft Excel is up to two times faster than using SET.NAME() on macro sheets. Similarly, using SET.VALUE() on a cell is up to two times faster than using assignment statements of the form "name=value". This procedure works because "name=value" is the same as the SET.NAME() macro function. Using SET.NAME() is up to two times faster than using DEFINE.NAME() to define names on a macro sheet. Whenever possible, use SET.VALUE() instead of FORMULA() to change the contents of a cell on a macro sheet. Using SET.VALUE() is up to three times faster than the same operation with the FORMULA() command. MORE INFORMATION This information was taken from pages 152-153 in the "Macro Tips" section of the "Microsoft Excel Technical Reference for the Macintosh" manual. The "Microsoft Excel Technical Reference for the Macintosh" is part of the Excel Developer's Kit. To obtain this kit, call Microsoft End User Sales and Service at (800) 426-9400.

KBCategory: kbother KBSubcategory: Additional reference words: 2.20 3.00 Last reviewed: April 3, 1997 © 1998 Microsoft Corporation. All rights reserved. Terms of Use.