Sub RngLike()
Dim rng As Range
Dim a As Integer
Dim nr As Integer
a = 1
nr = InputBox("请输入要查找的数据")
With Sheet1
.Range("A:A").ClearContents
For Each rng In .Range("B1:d22")
If rng.Text Like "*nr*" Then
.Range("A" & a) = rng.Text
a = a + 1
End If
Next
End With
End Sub