请测试:- Sub 汇总()
- Dim ar, re
- Dim i As Integer, j As Integer, Cnt As Integer
- ReDim re(1 To 99, 1 To Sheets.Count - 1)
- For i = 2 To Sheets.Count
- ar = Sheets(i).UsedRange
- Cnt = 0
- C = UBound(ar, 2)
- For j = 1 To UBound(ar)
- If ar(j, C) <> "" Then
- Cnt = Cnt + 1
- re(Cnt, i - 1) = ar(j, C)
- End If
- Next j
- Next i
- Sheets(1).[b1].Resize(UBound(re), Sheets.Count - 1) = re
- End Sub
复制代码 |