这样?- Sub CommandButton2_Click()
- Dim ARR, BRR, t$, i&, j&, k&, MaxRow&, MaxCol&, AR
- MaxRow = Cells(Rows.Count, "I").End(xlUp).Row
- MaxCol = Cells("18", Columns.Count).End(xlToLeft).Column
- ARR = Range("I18:O" & MaxRow)
- For n = 0 To MaxCol - 16 Step 4
- ReDim BRR(1 To UBound(ARR), 1 To 3)
- AR = Range("P18").Offset(0, n).Resize(UBound(ARR), 1)
- For i = 1 To UBound(ARR)
- t = AR(i, 1)
- For j = 1 To 3
- BRR(i, j) = "无"
- For k = 2 * j - 1 To 2 * j + 1
- If InStr(t, ARR(i, k)) > 0 Then BRR(i, j) = "OK": Exit For
- Next
- Next
- Next
- [Q18].Offset(0, n).Resize(UBound(BRR), 3) = BRR
- Next
- MsgBox "OK"
- End Sub
复制代码 |