Skovorodin Skovorodin is offline

Junior Member

Posts: 2

Quote:

Originally Posted by Skovorodin

Sometimes it is necessary to use a constant instead of variable in VBA Solver. Is there any way to solve the problem? It is described in the file switch.zip with macros.

Let us assume that Cell "$G$19" encloses a variable.
One approach to convert the variable into constant is to use the same value (for example, 1)
SolverAdd CellRef:="$G$19", Relation:=3, FormulaText:="1"
SolverAdd CellRef:="$G$19", Relation:=1, FormulaText:="1"

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I link a constant or variable to form	c1802362[_2_]	Excel Programming	4	September 13th 11 08:38 PM
Getting a constant/variable from another workbook?	Gustaf	Excel Programming	6	May 25th 09 01:07 PM
From variable to excel constant	Carmen	Excel Programming	2	December 6th 07 03:07 AM
How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4	Colfax	Excel Worksheet Functions	1	March 2nd 06 02:49 AM
Variable Acting Like a Constant?	George Boynton	Excel Programming	2	October 14th 05 04:06 PM

All times are GMT +1. The time now is 09:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us