你改为ActiveCell.FormulaR1C1 = "=SUM(表格3!c “& a & ": c ”& b & ")"
这样吗?
ActiveCell.Formula = "=SUM(表格3!C" & a & ":C" & b & ")"