Excel Solver Less Than or Equal To Constraint

Hello all,
I have some vba code to solve my system. Two of the constraints require variable values to be less than or equal to another cell value. However, for some reason solver always forces the variables to be equal to the other cell value instead of allowing it to be less than as well.
In the code below, the Var7 and Var8 are the variables forced to be equal to ConstraintValue2 instead of allowed to be less than. Anyone have any tips or ideas? Thanks in advance.

Please Login or Register  to view this content.

shg,
Sorry that was just a typing error when I was changing the names to post on here. Those two should be the same. Their values do not change in the course of the solution.
MrShorty,
There shouldn't be anything in the model that would cause solver to think that, but I will go through it and see if I notice anything.
Thanks

Follow-up:
I looked into the program and found two errors. The first was the way I was referencing cells on a different sheet. Solver didn't like that for some reason. The second error was the greater than or equal to constraint. The way the mathematical model works solver should have set the greater than or equal to variable (Result1) to the lowest value possible in order to minimize Result2 the overall objective of the solver. However, since there was no upper bound on Result1 solver instead choose to maximize Var7 and Var8 which resulted in Result1 being higher than necessary. I created a cell to calculate the error in Result1 and constrained it to zero and that fixed my issue.

Thanks for the replies.