Excel: SET.VALUE() Is Faster Than SET.NAME() and FORMULA()

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.