Hi there,
I have three defined named ranges, A, B and C.
They are all referencing a single column of numbers. They all have the same length.
I want to add constraints to solver based on these as follows:
for i = 1 to length_of(A)
constrain A<=B
constraint A>= C
next i
How can I achieve this in VBA ?
Many thanks in advance
Brocade
I have three defined named ranges, A, B and C.
They are all referencing a single column of numbers. They all have the same length.
I want to add constraints to solver based on these as follows:
for i = 1 to length_of(A)
constrain A<=B
constraint A>= C
next i
How can I achieve this in VBA ?
Many thanks in advance
Brocade