Microsoft KB Archive/37498

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 19:21, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q37498 to Microsoft KB Archive/37498 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Using SET.VALUE Formula with Array Name in Excel PSS ID Number: Q37498 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00 | 2.20 2.21 3.00 | 2.x 3.00



When the name Data on a macro sheet is used to refer to the array {1,2,3,4}, the value 1 is incorrectly transferred into cells B1:E1 when the the following SET.VALUE command is used:


The values are transferred correctly if the following formula is entered:


To use a name that references an array, the formula (in this case, the SET.VALUE command) must be entered as an array (press CTRL+SHIFT+ENTER).

More Information:

In the first example above, the values 1,2,3,4 will be entered in B1:E1 once the SET.VALUE formula is entered as an array.

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0

Copyright Microsoft Corporation 1993.