最佳答案
Sub 销售竞赛日统计表()
Dim ran As Range, mycol As Long
mycol = Range("iv1").End(xlToLeft).Column
Cells(2, mycol).Select
ActiveCell.Formula = "=SUM(RC8:RC[-1])"
Set ran = Range(Cells(2, mycol), Cells(45, mycol))
Selection.AutoFill Destination:=ran
Set ran = Nothing
End Sub