Microsoft KB Archive/51067

{| = Excel: SET.VALUE Is Faster Than SET.NAME and FORMULA =
 * width="100%"|

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 &quot;name=value&quot;. This procedure works because &quot;name=value&quot; 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 &quot;Macro Tips&quot; section of the &quot;Microsoft Excel Technical Reference for the Macintosh&quot; manual.

The &quot;Microsoft Excel Technical Reference for the Macintosh&quot; is part of the Excel Developer's Kit. To obtain this kit, call Microsoft End User Sales and Service at (800) 426-9400.
 * }