主题：[求助] 如何在公式中给新增加的表的列设置刷新公式？

如何在公式中给新增加的表的列设置刷新公式？

我用公式了，但增加的表列不显示刷新公式，请老师检查一下：
If([%年度数%] <= 1,MsgBox("你要概算就填写年数!",0),If(MsgBox("你确定要把概算分为"+Text([%年度数%])+"年计划吗？",2,4),Eval(mid(Rept(" And RemoveGrid(3)",Grids-2),5)) And Eval(mid(Rept(" And CreateGrid(""第""+Text(Grids-1)+""年"",""单位工程名称"",0,""单位"",0,""工程量"",1,""单价"",1,""概算价值"",1,""指标"",1,""审核"",3)",[%年度数%]),5)) And Eval("ClearGrid("""+Substitute(Substitute(Substitute(ListGrids(),"概算|",""),"辅助|",""),"|",""") And ClearGrid(""")+""")") And Eval("CopyRows("""+Substitute(Substitute(Substitute(ListGrids(),"概算|",""),"辅助|",""),"|",""") And CopyRows(""")+""")") And Eval("DelRow("""+Substitute(Substitute(Substitute(ListGrids(),"概算|",""),"辅助|",""),"|",""",1) And DelRow(""")+""",1)") And Eval("EvalFor("""+Substitute(Substitute(Substitute(ListGrids(),"概算|",""),"辅助|",""),"|",""",""工程量"",""[工程量]/[%年度数%]"") And EvalFor(""")+""",""工程量"",""[工程量]/[%年度数%]"")") And Eval("EvalFor("""+Substitute(Substitute(Substitute(ListGrids(),"概算|",""),"辅助|",""),"|",""",""概算价值"",""[概算价值]/[%年度数%]"") And EvalFor(""")+""",""概算价值"",""SetColFormula(GridName,""概算价值"",""[工程量]/[%年度数%]*[单价]"")"")"), True )) And ClearGrid("辅助") And CopyRows("辅助") And DelRow("辅助",1) And SetVariable("%A%",1) And Eval(mid(Rept(" And DeleteCol(""辅助"",2)",[辅助!Cols]-1),5)) And Eval(mid(Rept(" And AddCol(""辅助"",""工程量""+Text([%A%]),1, True ) And AddCol(""辅助"",""概算价值""+Text([%A%]),1, True ) And SetVariable(""%A%"",[%A%]+1)",[%年度数%]),5))

-=-=-=- 以下内容由 hcy1185 在 2011年08月03日 08:43am 时添加 -=-=-=-
If([%年度数%] <= 1,MsgBox("你要概算就填写年数!",0),
请问，能不能去掉此句？