XL: Error Running Solver Macro with Non-Comma List SeparatorsLast reviewed: September 3, 1997Article ID: Q161620 |
The information in this article applies to:
SYMPTOMSIn the programs listed at the beginning of this article, when you run a recorded Visual Basic for Applications macro that uses the Solver functions, you may receive the following error message:
Run Time Error '1004' Error in Formula CAUSEThis problem occurs if you set the Regional Settings in the Control Panel under Windows 95, or the International Settings in the Control Panel under Windows 3.1 or 3.11, to anything other than "English (United States)". The Solver functions use the comma (,) as a list separator to separate the arguments of the function. Setting the Regional Settings to anything other than "English (United States)" changes the list separator to something other than a comma.
RESOLUTIONTo resolve this behavior, set the Regional Settings in the Control Panel under Windows 95, or the International Settings in the Control Panel under Windows 3.1 or 3.11, to "English (United States)." To do this, use the following appropriate steps:
Windows 95
Windows 3.1, or 3.11
STATUSThis behavior is by design of Microsoft Excel.
REFERENCESFor more information about changing the regional settings, click the Index tab in Windows 95 Help, type the following text
regional settingsand then double-click the selected text to go to the "regional settings, changing" topic.
|
Additional query words: 5.00 5.00c 7.00
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |