Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to use solver for equations in certain locations in a sheet. To
do this I would like to pass the activerow to the solver arguments. I was able to do something similar in GoalSeek but it doesn't work in Solver. Here's my code activerow = ActiveCell.Row SolverOk SetCell:=Cells(activerow, 14), MaxMinVal:=3, ValueOf:="0", ByChange:=Cells(activerow, 12) I'm not sure I understand why this doesn't work but hopefully there's a simple solution Any help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Solver with multiple ranges (Excel 2003 sp2) | Excel Programming | |||
Moving ranges as input for Solver | Excel Programming | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Solver and dynamic ranges | Excel Worksheet Functions | |||
Resetting Solver Manually to Fix Solver Bug | Excel Programming |