Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Macro doesn't work in Excel 2010
I tried the assumeNonNeg thing after reading your other thread. It was relevant as my results are often negative, but did not seem to help. However, when I re-recorded the macro but omitted the SolverReset function, the macro works perfectly. It was this function that seemed to be throwing the...- rammo123
- Post #6
- Forum: Microsoft: Office
-
Macro doesn't work in Excel 2010
Here is the code. I've had a look around the web and I'm sure it's something to do with referencing solver.xlam. Sub Solve_DewPoint() 'Solve_DewPoint Macro Range("B4").Value = -5 SolverReset SolverOk SetCell:="$F$22", MaxMinVal:=2, ByChange:="$B$4" SolverSolve True End Sub- rammo123
- Post #4
- Forum: Microsoft: Office
-
Macro doesn't work in Excel 2010
I am very much a VBA noob. I have created a simple macro that automatically uses solver to find a solution to a problem. The macro works fine on my workstation, but when I try to use it on a computer with Excel 2010 installed, the output value always resets to 0. Any suggestions?- rammo123
- Thread
- Replies: 5
- Forum: Microsoft: Office
