Using Solver.Ok from VBA Requires R1C1 Style Referencing
When you call the Solver.Ok macro function from a Visual Basic for Applications procedure or macro, you need to use R1C1 notation when referencing cell ranges on a worksheet. If you use A1 notation in referencing cell ranges, you may receive the......