| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue with Solver
Thanks for your help Dana.
-- Robert "Dana DeLouis" wrote: "Valueof" is set to -- in one case it works, in the other it doesn't...doesn't make sense as to why this would be. Hi. The "Value of" is expecting a number. ValueOf:="$AL$1", _ is simply setting it to a string "$AL$1" , and solver does not see this as a value "From AL1" ValueOf:=Range("AL1").Value, _ This takes the value in AL1, and places it into solver. This should work. If you record a macro while doing a simple Solver example, you will notice that you can not place a Cell Address (A stirng like A1) in the "Value of" box. This is by design to prevent Solver from going around in circles. You need to place a value here. What is the "trace precedence" key? I looked in Solver and then googled it but didn't find anything. This is not part of Solver, but a feature of an Excel worksheet. It is a button you can find on the formula auditing toolbar. (On the Formula Tab in Excel 2007) You can select any cell, and select Trace Dependent / Precedent and see which cells are related to the selected cell in question. (You can keep clicking the button to keep going up/down levels.) -- HTH :) Dana DeLouis "robs3131" wrote in message ... Cell AL1 is a constant -- it does not change as the results change. You'll notice that in both examples from my most recent post, cell AL1 is the what "Valueof" is set to -- in one case it works, in the other it doesn't...doesn't make sense as to why this would be. What is the "trace precedence" key? I looked in Solver and then googled it but didn't find anything. Thanks for your help, -- Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Solver Update Issue | Excel Discussion (Misc queries) | |||
| Solver Update Issue | Excel Worksheet Functions | |||
| excel 2000 post service pack 3 hotfix - correct an issue with solver with VBA | Excel Programming | |||
| Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
| Excel Solver Issue | Excel Discussion (Misc queries) | |||
Threaded Mode
