Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default SolverOK, he not so OK

Anyone give us an idea about this one?. When I run this
basic macro, the settings of SolverOK do NOT get inputted
into the solver addin but the constraints do. (i.e.
SolverAdd works, SolverOK does not). If I manually record,
VBA recognises that I am using SolverOK and records my
actions, but when I play back, the macro totally ignores
the solverOK line. Any suggestions? Thanks Toby

Sub SolveMacro()
SolverReset
SolverAdd CellRef:="$B$1", Relation:=2,
FormulaText:="0.1"
SolverOK SetCell:="$A$1", MaxMinVal:=1, ValueOf:="0",
ByChange:="$C$1:$C$4"
SolverSolve True
End Sub
..


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SolverOK problem - very frustrated, please help Daniel E Excel Programming 1 January 29th 04 09:40 PM
SolverOK Problem after SP-3 Update Joe Zaccardi Excel Programming 2 September 27th 03 03:43 AM


All times are GMT +1. The time now is 11:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"