Hi guys, I am wanting to find the optimum product mix and profit for a purchase decision using VBA but without solver. The product mix can vary each week and lets just say for ease of use the are 5 weeks. There are two products (CD's and DVD's) that have different costs (storage costs, purchase costs etc). I have built a model that already takes all of this into account and so the only things I need to vary to affect profit are the amount purchased each week. Lets say we have a limit of 6 CDs and 6 DVDs a week. I am wanting to use VBA code that will test all possible outcomes and will then show the optimal outcome.

If its easier for you guys let;

A1 = CD's purchased in Week 1
A2 = DVD's purchased in Week 1

B1 = CD's purchased in Week 2
B2 = DVD's purchased in Week 2

etc.

Any help would be greatly appreciated, thank you!