Referencing the addressess of a defined name range in VBA and adding as constraint to Solver

[Brocade]

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