| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is there anyway to call the Solver add-in as a function?
No.
A function can only return a value to be shown in the cell(s) in which it is entered. Solver works by changing various worksheet cells as it deems fit to find an optimal solution. That makes it impossible to use Solver as a function. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... 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? |
| 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 | |||
| is there anyway to call the Solver add-in as a function? | Excel Programming | |||
| Function Call | Excel Programming | |||
Threaded Mode
