Advanced Loop in macro find maximum value

Hi,
I've an excelsheet with quite advanced formulas that area really nested and using quite a bit of iteration.

What I would like to do is finding the maximum of

A while Amin<A<Amax
By changing B

There is a Variable C than should be constant unless it becomes larger than Cmax ( Cmax dependas on A,B ,C, D and all kinds of things)

If C is > than Cmax there is a variable D that can be changed has to be less or equal to Dmax

So the question is how to find the maximum of A while fulfilling all these variables?

What I've come up with so far is:

Please Login or Register  to view this content.

It's not really correnct since the MAx values of A B and C can change which means that the loop can exit without all satements fulfilled.

Could you help me please?

AS I understood the user need to have the solver function installed on his/her local computer. Therefore I though it would be better to have something that can run on all computers.

DOn't you think it can be done with loops`?
Best regards

Andy

THanks I'll look into the solver solution to this problem.
Allthough As an exercise I would appreciate a solution using loops. COuld you help out?

Br
Andy

IT's taking values from some other workbook on the network. THe file I have on my computer is not enough to run the formulas. nevertheless the problem is as stated about. Looking forward to your expert advice.

Br

Andy

What do you mean with mocking?