Sub CommandButton2_Click()
Dim ARR, BRR, t$, i&, j&, k&, MaxRow&, MaxCol&, AR
MaxRow = Cells(Rows.Count, "G").End(xlUp).Row
MaxCol = Cells("18", Columns.Count).End(xlToLeft).Column
ARR = Range("G18: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 = 3 * j - 2 To 3 * j
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
End Sub |