LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Missing condition after solver called by macro


All,
Sam solved our problems. Apparently, some graphics/pictures/graphs
will cause the macro to ignore solver conditions involving positive
integers less than 15. If that happens to you, delete any
pictures/graphs one by one until your macro works. Once you have your
picture(s) isolated, then you should be able to delete only the problem
picture(s) and leave all the rest.

If you can't live without the problem picture(s), the only other option
is to change the number. For example, if your limit is supposed to be
5, instead use 4.9999999


--
halfsoul
------------------------------------------------------------------------
halfsoul's Profile: http://www.excelforum.com/member.php...o&userid=34063
View this thread: http://www.excelforum.com/showthread...hreadid=492647

 
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
Solver Table missing in Data Menu of Excel2003. Where is it? Guaylen Excel Worksheet Functions 2 November 14th 04 08:54 PM
Solver not Using Constraints when called from VB Mark[_47_] Excel Programming 0 July 8th 04 08:57 PM
Worksheet_Change sub does not trigger a called macro herman Excel Programming 3 February 8th 04 08:30 PM
Solver code does not save results to sheet - What am I missing?! Simon Livings Excel Programming 0 January 16th 04 03:55 PM
which FormField called a macro? Juggernath[_2_] Excel Programming 0 January 15th 04 12:58 PM


All times are GMT +1. The time now is 07:43 PM.

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"