|
Sub mm()
Dim Sht1 As Worksheet, Sht As Worksheet
Dim Myr&, n&, Arr
Application.ScreenUpdating = False
Set Sht1 = Sheet17
Sht1.[a3:ai10000].ClearContents
For Each Sht In Sheets
If InStr(Sht.Name, "月") Then
Myr = Sht.[a65536].End(xlUp).Row
Arr = Sht.Range("a3:ai" & Myr)
n = Sht1.[a65536].End(xlUp).Row + 1
Cells(n, 1).Resize(UBound(Arr), UBound(Arr, 2)) = Arr
End If
Next
Application.ScreenUpdating = True
End Sub
Sht1.[a2:ai10000].ClearContents
把A3改成A2
|
|