标志“有”还容易一点,需要的话再将未标“有”的标为“无”:
Sub 复制()
'................
For j = 1 To UBound(arr)
If arr(j, 1) <> "" And InStr(q, arr(j, 1)) > 0 Then
k = 1
Cells(j + 1, 2) = "有"
Exit For
End If
Next j
'...........
End Sub
标志“有”还容易一点,需要的话再将未标“有”的标为“无”:
Sub 复制()
'................
For j = 1 To UBound(arr)
If arr(j, 1) <> "" And InStr(q, arr(j, 1)) > 0 Then
k = 1
Cells(j + 1, 2) = "有"
Exit For
End If
Next j
'...........
End Sub