Sub test()
Dim i, j, k As Integer
Dim p As String
i = 1
j = Sheet2.[a65535].End(xlUp).Row
p = CStr(Sheet1.[b3])
For k = 1 To j
q = CStr(Sheet2.Cells(k, 1))
If InStr(q, p) <> 0 Then
Sheet3.Cells(i, 1) = Sheet2.Cells(k, 1)
i = i + 1
End If
Next
End Sub
追问运行到Sheet3.Cells(i, 1) = Sheet2.Cells(k, 1)出错
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4ec2d5628535e5ddf2c2e33576c6a7efcf1b6269?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追答这段代码,我自己测试过的。你注意下,这段代码是个sub,过程。你需要在excel里面,插入一个模块,把这段代码放到模块中,然后运行使用。而不是放到某个worksheet中。
来自:求助得到的回答