|
Sub test()
Dim ar, br, i&, j&, iCol&, wks As Worksheet
ReDim br(1 To 10000, 1 To 32)
With Sheets(1)
iCol = .Cells(1, Columns.Count).End(xlToLeft).Column
For i = 1 To iCol
br(1, i) = .Cells(1, i)
Next i
End With
r = 1
For Each wks In Worksheets
With wks
ar = .[A1].CurrentRegion
For i = 1 To UBound(ar)
If InStr(ar(i, 13), "设计") Then
r = r + 1
For j = 1 To 32
br(r, j) = ar(i, j)
Next j
End If
Next i
End With
Next wks
If r > 1 Then
With Workbooks.Add
With .Sheets(1).[A1].Resize(r, 32)
.Value = br
.HorizontalAlignment = xlCenter
.Borders.LineStyle = xlContinuous
.Rows(1).Font.Bold = True
'.EntireColumn.AutoFit
.EntireRow.AutoFit
End With
End With
End If
Beep
End Sub
|
|