Sub wayy()
Set Rng = Sheets("Sheet1").Columns("B:B").Find([a1])
If Not Rng Is Nothing Then
[c2] = "此人在" & Rng.Row & "行"
Else
MsgBox "查无此人!"
End If
End Sub
Sub fc()
With Sheets("sheet2")
k = Sheets("sheet1").Range("B65536").End(3).Row
a = WorksheetFunction.CountIf(Sheets("sheet1").Range("B1:B65536" & k), Range("A1"))
If a = 0 Then
MsgBox "查无此人!"
[c2] = ""
Else
[c2] = "OK!"
End If
End With
End Sub
Sub wayy()
Set Rng = Sheets("Sheet1").Columns("B:B").Find([a1])
If Not Rng Is Nothing Then
[c2] = "此人在" & Rng.Row & "行"
Else
MsgBox "查无此人!"
End If
End Sub