Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is there anyway to call the Solver add-in as a function?
Solver is tightly tied to worksheet cells. You can set up and run
Solver from VBA, but you would still have to load and change workseet cells. A VBA function that is called from a worksheet can only return a value, it cannot modify its environment (in particular it cannot change cell values), and thus cannot use Solver. A VBA function could use solver when called from a Sub instead of a worksheet cell. Jerry JParshley wrote: I would like to call the Solver add-in as a function from a cell and feed it the input parameters on the main Solver dialog box. Is there a way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having Solver Call a macro for each iteration | Excel Discussion (Misc queries) | |||
Is there a do not call function? | Excel Discussion (Misc queries) | |||
how i can call the function | Excel Worksheet Functions | |||
Function Call | Excel Programming | |||
call function | Excel Programming |