Error Running Solver Macro with Non-Comma List Separators (161620)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0c
This article was previously published under Q161620 SYMPTOMS
In 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
CAUSE
This 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.
RESOLUTION
To 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- On the Start menu, point to Settings, and then click Control Panel.
- Double-click the Regional Settings icon.
- Click the Regional Settings tab.
- In the setting box, click "English (United States)" and click OK.
Windows 3.1, or 3.11- In the Main group in Program Manager, double-click Control Panel.
- Double-click the International icon.
- In the Country list, click United States. In the Language, click
"English (United States)" and click OK.
STATUS
This behavior is by design of Microsoft Excel.
REFERENCES
For more information about changing the regional settings, click the Index
tab in Windows 95 Help, type the following text
and then double-click the selected text to go to the "regional settings,
changing" topic.
| Modification Type: | Minor | Last Reviewed: | 10/10/2006 |
|---|
| Keywords: | KB161620 |
|---|
|