|
数组法- Sub FindInarr()
- Dim arr, result(1 To 1000, 1 To 2)
- Dim i As Long, j As Long
- Dim lCount As Long
- On Error GoTo ErrorHandler
- With Worksheets("sheet1")
- arr = .Range(.Range("a2"), .Cells(Rows.Count, "f").End(xlUp)).Value
- End With
- For i = LBound(arr) To UBound(arr)
- For j = LBound(arr, 2) To UBound(arr, 2) Step 2
- If arr(i, j) = "A" Then
- lCount = lCount + 1
- result(lCount, 1) = "A"
- result(lCount, 2) = arr(i, j + 1)
- End If
- Next
- Next
- If lCount Then
- With Worksheets("A")
- .Range("a2").Resize(lCount, 2).Value = result
- End With
- MsgBox "提取完成", vbInformation
- Else
- MsgBox "没有匹配的数据", vbCritical
- End If
- Exit Sub
- ErrorHandler:
- MsgBox Err.Number & vbCrLf & Err.Description
- End Sub
复制代码 |
|