|
- Sub 方法2()
- Dim i As Long
- Dim k As Long
- Dim m As Long
- Dim arr
- Dim lP As Long
- Dim blExit As Boolean
- Dim t#
- t = Timer
- arr = Range("a1:g" & Cells(Rows.Count, 1).End(xlUp).Row + 1)
- Application.ScreenUpdating = False
- Columns("p").ClearContents
- For i = LBound(arr) To UBound(arr)
- k = i
- blExit = True
- Do Until Len(arr(k, 1)) = 0
- If arr(k, 1) <> arr(k, 4) Then blExit = False ': Exit Do
- k = k + 1
- Loop
- If blExit And k - i = 4 Then
- lP = lP + 1
- Cells(lP, "p") = arr(k - 1, 7)
- End If
- i = k
- Next
- Application.ScreenUpdating = True
- t = Timer - t
- MsgBox "提取完成" & vbCrLf & t & "秒", vbInformation + vbOKOnly
- End Sub
复制代码 |
|