|
我录制了一个规划求解的宏,打开VBE后显示红色代码,调试时弹出语法错误,怎么解决呢??请老师指教!谢谢
- Sub Macro1()
- SolverOk SetCell,:="$B$3", MaxMinVal:=3, ValueOf:="960", yChange:="$A$1:$A$3"
- SolverDelete CellRef,:="$B$1", Relation:=2, ormulaText:="$C$1"
- SolverAdd CellRef,:="$B$1", Relation:=2, ormulaText:="$C$1"
- SolverOk SetCell,:="$B$3", MaxMinVal:=3, ValueOf:="960", yChange:="$A$1:$A$3"
- SolverSolve
- End Sub
复制代码
本帖最后由 hhzjxss 于 2011-4-20 13:13 编辑
- Sub Macro1()
- Range("A1:A3").ClearContents
- Application.ScreenUpdating = False
- Application.EnableEvents = False
- SolverOk SetCell:="$B$3", MaxMinVal:=3, ValueOf:="960", ByChange:="$A$1:$A$3"
- SolverOk SetCell:="$B$3", MaxMinVal:=3, ValueOf:="960", ByChange:="$A$1:$A$3"
- SolverSolve Userfinish:=True
- Application.ScreenUpdating = True
- Application.EnableEvents = True
- End Sub
-
- ''记得在VBE界面“引用”中勾选“SOLVER”
-
-
-
复制代码
|
|