Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: reeee
  • Content: Threads
  • Order by date
  1. reeee

    Problem with solver constraints

    Can anyone help with this solver VBA code? basically it refuses to set the constraint for cells(106,3+chkcount) to 1 ****solveradd cellref:=Sheet1.Cells(106, 3 + chkcount), relation:=3, formulatext:=1*** If I change this to zero it works but not 1... Doesn anyone know why? I thought it was...
  2. reeee

    Excel solver problems

    Hi, I am trying to use Excel solver to give me the minimum possible number for a problem that I have, the number selected in the jpeg attached are the ones that solver has been told to change so as to get the number shown as orange to it's lowest possible point. This number is worked out from a...

Part and Inventory Search