Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel Solver multiple times with macros
Is there a way to use dummy indices in macros in order to invoke Solver
multiple times? I want to solve for the value in column D by changing the values in columns A and B, based on the value in Column C being constrained. Rather than having cell references be definitive (i.e. "$A$1"), I want to put the solver functions in a loop (An), where n varies up to 800, so that I can invoke solver on 800 lines of data. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use Excel Solver (for an Iteration in a row) for several no.of times? | Excel Discussion (Misc queries) | |||
solver in macros | Excel Discussion (Misc queries) | |||
webquery and solver macros | Excel Discussion (Misc queries) | |||
Solver, macros Excel | Excel Worksheet Functions | |||
Using solver in macros - Help | Excel Programming |