第1个回答 2023-02-21
Sub ss()
Dim St$, AddrF$, Rng As Range
St = "张三"
Set Rng = Cells.Find(St)
If Not Rng Is Nothing Then
AddrF = Rng.Address
If Cells.FindNext(Rng).Address = AddrF Then
'只有一个
Else
MsgBox "找到但是不唯一"
End If
Else
MsgBox "没有找到"
End If
End Sub
基本框架就这样,需要自行拓展和限制查找位置等自便。