I am very new to Macro!
I have a simple solver program that wants to go through columns rather than rows. I had a play about to try and model this but it says there is a global error
How do I go about this?
Please help!Sub Macro1() Dim i As Integer For i = 1 To 5 ActiveCell.Select SolverOk SetCell:=Range("ad + i" & 4), MaxMinVal:=2, ValueOf:=0, ByChange:=Range("p + i" & 1 & ":" & "p + i" & 3), _ Engine:=1, EngineDesc:="GRG Nonlinear" SolverSolve True Next i End Sub
Thank you
Bookmarks