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