View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
traima traima is offline
external usenet poster
 
Posts: 23
Default Solver in macros

How is it possible to create a macro that uses Solver to calculate a target
cell, by changig the value of an inputbox?


So far I have recorded the solver code like this:

SolverOK SetCell:="$H$25", MaxMinVal:=3, ValueOf:=Nettverk, ByChange:="$C$16"

Nettverk is defined as the value of the inputbox. What am I missing to
complete this?