猜了一个你的意思,估计是: Sub 模糊查找() '薄内快速模糊查找 On Error Resume Next Dim Flag As Boolean, arr, I&, J& Application.ScreenUpdating = False Application.EnableEvents = False With Sheets("基本信息输入") arr = .Range("A11:R" & .[A65536].End(xlUp).Row) End With With Sheets("电话簿") For I = LBound(arr) To UBound(arr) If arr(I, 1) = "" Then arr(I, 1) = arr(I - 1, 1) For J = 2 To UBound(arr, 2) If arr(I, J) Like "*" & .[E6].Value & "*" Then Flag = True Exit For Else Flag = False End If Next If Not Flag Then arr(I, 1) = "=1/0" Next .[B9:M65536] = "" .[B9].Resize(UBound(arr), UBound(arr, 2)) = arr .[B9].Resize(UBound(arr), 1).SpecialCells(xlCellTypeFormulas, xlErrors).EntireRow.Delete End With Application.EnableEvents = True End Sub PS:但我不认为这个是最好的 |