|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
试试
- Sub getData(sName$)
- Dim arr, ghb(1 To 2000, 1 To 28)
- Dim i%, k%, j%
- arr = Sheets("10月份木纹机台产量").UsedRange
- For i = 2 To UBound(arr)
- If InStr(arr(i, 4), sName$) Then
- k = k + 1
- ghb(k + 1, 1) = k
- For j = 2 To UBound(arr, 2)
- ghb(k + 1, j) = arr(i, j)
- Next
- End If
- Next
- If k = 0 Then GoTo ghb
- For i = 1 To UBound(arr, 2)
- ghb(1, i) = arr(1, i)
- Next
- With Sheets(sName)
- .Cells.Clear
- .[a1].Resize(k, 28) = ghb
- End With
- ghb:
- End Sub
- Sub kaohsing()
- Dim sh As Worksheet
- Application.ScreenUpdating = False
- For Each sh In Worksheets
- If sh.Name <> "10月份木纹机台产量" Then
- getData sh.Name
- End If
- Next
- Application.ScreenUpdating = True
- MsgBox " job is okey"
- End Sub
复制代码 |
|