Hi<
I'm looking at a workbook someone else created.
When I right click on the "SolverSolve" or the "SolverReset" in the macro below, it says "Can't display hidden procedure".
What does this mean? How can I see the procedure?
I'm looking at a workbook someone else created.
When I right click on the "SolverSolve" or the "SolverReset" in the macro below, it says "Can't display hidden procedure".
What does this mean? How can I see the procedure?
Rich (BB code):
Sub SolveMac()
Dim ASF As Double
Dim Curr As Workbook
Set Curr = ActiveWorkbook
Curr.Sheets("Input").Activate
SolverReset
SolverOk SetCell:="Solve_Net_Gap", MaxMinVal:=3, ValueOf:=0, ByChange:="Solve_ASF_Charge", Engine _
:=1, EngineDesc:="GRG Nonlinear"
SolverSolve (True)
ASF = Range("Solve_ASF_Charge").Value
Range("Solve_ASF_Charge").Value = Application.WorksheetFunction.RoundUp(ASF, 4)
End Sub
Last edited by a moderator: