|
Sub test()
Dim i, n
n = Sheets.Count
ReDim A(1 To n - 1) '工作表范围
For i = LBound(A) To UBound(A)
A(i) = "'" & ThisWorkbook.Path & "\[" & ThisWorkbook.Name & "]" & Sheets(i).Name & "'!R1C1:R65536C2"
Next i
Sheets(n).Select
Cells.Clear
[a1].Consolidate Sources:=A, Function:=xlSum, TopRow:=True, LeftColumn:=True
End Sub
问题附件.rar
(18.73 KB, 下载次数: 7)
|
|