Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Difference between revisions of "Microsoft KB Archive/24640"

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
 
Line 11: Line 11:
 
== SUMMARY ==
 
== SUMMARY ==
  
A macro error will occur at a cell containing a SET.VALUE() function if the ACTIVE.CELL() function is used as the "ref" argument of the SET.VALUE() command.
+
A macro error will occur at a cell containing a SET.VALUE() function if the ACTIVE.CELL() function is used as the "ref" argument of the SET.VALUE() command.
  
For example, if a macro is run that contains the function "=SET.VALUE(ACTIVE.CELL(),10)" in cell A5, a macro error will occur at cell A5.
+
For example, if a macro is run that contains the function "=SET.VALUE(ACTIVE.CELL(),10)" in cell A5, a macro error will occur at cell A5.
  
The SET.VALUE() function can only contain an actual reference to a cell on the macro sheet. The "ref" argument cannot be a reference to any cell outside the macro sheet or the ACTIVE.CELL() function.
+
The SET.VALUE() function can only contain an actual reference to a cell on the macro sheet. The "ref" argument cannot be a reference to any cell outside the macro sheet or the ACTIVE.CELL() function.
  
To place a particular value in a cell on the active worksheet, the FORMULA() command can be used. For example, to enter a 10 in the active cell, use the formula "=FORMULA(10)".
+
To place a particular value in a cell on the active worksheet, the FORMULA() command can be used. For example, to enter a 10 in the active cell, use the formula "=FORMULA(10)".
 
|}
 
|}
  

Latest revision as of 12:50, 21 July 2020


Excel: ACTIVE.CELL() Within SET.VALUE() Returns Macro Error

Last reviewed: November 2, 1994
Article ID: Q24640

SUMMARY

A macro error will occur at a cell containing a SET.VALUE() function if the ACTIVE.CELL() function is used as the "ref" argument of the SET.VALUE() command.

For example, if a macro is run that contains the function "=SET.VALUE(ACTIVE.CELL(),10)" in cell A5, a macro error will occur at cell A5.

The SET.VALUE() function can only contain an actual reference to a cell on the macro sheet. The "ref" argument cannot be a reference to any cell outside the macro sheet or the ACTIVE.CELL() function.

To place a particular value in a cell on the active worksheet, the FORMULA() command can be used. For example, to enter a 10 in the active cell, use the formula "=FORMULA(10)".


KBCategory: kbother

KBSubcategory:

Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00


Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.