Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 661
Default VBA SolverOK not inputting all values into Solver...

I am using VBA to invoke and configure Solver, but all of the information is
not being inserted by the SolverOK VBA command:

SolverOk SetCell:="$B$53", MaxMinVal:=3, ValueOf:="25",
ByChange:="$B$46:$B$51"

The value for the Set target cell field is to be $B$53 and the By changing
values field to be $B46:$B51. The value of 25 is inserted and the correct
logic is set (MaxMinVal;=3), which equates the target cell ($B$53) with the
value of 25. The balance of the code (constraints and options) works OK.

Why are the SetCell and ByChange values not making it into Solver using VBA
SolverOK?
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
Can I use solver to estimate several values by changing several c. AO Excel Worksheet Functions 1 June 24th 08 07:09 AM
Asking Excel Solver to use binaries, but selects other values Stephane Excel Discussion (Misc queries) 3 June 23rd 05 11:25 PM
SolverOK, he not so OK toby Excel Programming 0 July 30th 04 01:09 PM
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:21 PM.

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

About Us

"It's about Microsoft Excel"