Dim arr
arr = Worksheets("关键词").Range("a2:b" & Worksheets("关键词").[a10000].End(3).Row)
For i = 2 To Worksheets("清单").[a65000].End(3).Row
bz = False
If s = "主要关键词" Then
s1 = Worksheets("清单").Cells(i, 1)
For k = 1 To UBound(arr)
If arr(k, 1) = s1 Then
bz = True
Exit For
End If
Next k
Else