View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tdogg241
 
Posts: n/a
Default Writing a macro that updates solver solutions?

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.