|
参与一下。。。
- Sub ykcbf() '//2024.5.23
- Application.ScreenUpdating = False
- Set sh = ThisWorkbook.Sheets("合并表")
- ReDim brr(1 To 10000, 1 To 16)
- For Each sht In Sheets
- If sht.Name <> sh.Name And InStr(sht.Name, "供应商") = 0 And sht.Name <> "模板" And sht.Name <> "现存量" Then
- With sht
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .[a5].Resize(r - 4, 14)
- For i = 4 To UBound(arr)
- If arr(i, 1) <> Empty Then
- m = m + 1
- For j = 1 To UBound(arr, 2)
- brr(m, j) = arr(i, j)
- Next
- brr(m, 15) = .[h4]
- brr(m, 16) = .[e4]
- End If
- Next
- End With
- End If
- Next
- With sh
- .[a7:p10000] = ""
- .[a7].Resize(m, 16) = brr
- End With
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
2
查看全部评分
-
|