Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to write a macro that will update several cells that are calculated
using the solver function. So far, the only way I've found to do this is to update them one-by-one which is very tedious. So I'm trying to write a macro that will do this easily. I tried recording the macro and doing it manually, which gave me the following code: SolverOk SetCell:="$F$32", MaxMinVal:=3, ValueOf:="100", ByChange:="$A$32" SolverSolve Unfortunately, when I try to run the macro, it says that the SolverOk function is not a valid function. So I'm not sure what I can do to fix this. Any help is greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible to run Solver using a macro? | Excel Worksheet Functions | |||
Macros involving SOLVER... function | Excel Discussion (Misc queries) | |||
webquery and solver macros | Excel Discussion (Misc queries) | |||
Macro writing a Macro | Excel Discussion (Misc queries) | |||
Macro Help In Excel | Excel Discussion (Misc queries) |