|
Sub demo()
Dim ar, br(1 To 60000, 1 To 22)
For x = 2 To Sheets.Count
If Sheets(x).Name Like "?" Then
m = Sheets(x).Cells(Rows.Count, 1).End(3).Row
If m > 4 Then
ar = Sheets(x).Range("A4:V" & m)
For i = 1 To UBound(ar)
n = n + 1
For j = 1 To UBound(ar, 2)
br(n, j) = ar(i, j)
Next
Next
End If
End If
Next
Sheet1.Columns("f:g").NumberFormatLocal = "@"
Sheet1.Range("f6").Resize(n, 22) = br
End Sub |
评分
-
查看全部评分
|