Sub Test()
Dim i, A(1 To 12), x
For i = 1 To UBound(A)
A(i) = "'F:\Downloads\汇总表\[汇总表.xls]" & i & "月'!R1C3:R6C6"
Next i
'对第1到12个工作表合并计算,C1:F6求和
With Range("c1")
x = .Value
Range("c:f").ClearContents
.Consolidate Sources:=A, Function:=xlSum, TopRow:=True, LeftColumn:=True
.Value = x
End With
End Sub 汇总表2.rar(11.79 KB, 下载次数: 20)
Sub Test()
Dim i, A(1 To 12), x
For i = 1 To UBound(A)
A(i) = "'F:\Downloads\汇总表\[汇总表.xls]" & i & "月'!R1C3:R6C6"
Next i
'对第1到12个工作表合并计算,C1:F6求和
With Range("c1")
x = .Value
Range("c:f").ClearContents
.Consolidate Sources:=A, Function:=xlSum, TopRow:=True, LeftColumn:=True
.Value = x
End With
End Sub 汇总表2.rar(11.79 KB, 下载次数: 20)