|
- Sub yy()
- Dim Brr, i&, Myr&, Err, j&, a$
- Sheet1.Activate
- [g:g].ClearContents
- Brr = [b4].CurrentRegion
- Myr = [e65536].End(xlUp).Row
- Err = Range("e4:e" & Myr)
- For i = 1 To UBound(Err)
- If Err(i, 1) <> "" Then
- For j = 1 To Len(Err(i, 1))
- a = Mid(Err(i, 1), j, 1)
- If InStr(Brr(i + 1, 1), a) Then
- Cells(i + 4, 7) = "OK": GoTo 100
- End If
- Next
- For j = 1 To Len(Err(i, 1))
- If InStr(Brr(i + 2, 1), a) Then
- Cells(i + 4, 7) = "1": i = i + 1: GoTo 100
- End If
- Next
- For j = 1 To Len(Err(i, 1))
- If InStr(Brr(i + 3, 1), a) Then
- Cells(i + 4, 7) = "2": i = i + 2: GoTo 100
- End If
- Next
- i = i + 3
- End If
- 100:
- Next
- End Sub
复制代码 |
|