VBA的话,用range的find方法吧
Sub test()
Dim mrg As Range
Dim firstaddress
Dim alladdress
With Range("j:j")
Set mrg = .Find("*", lookat:=xlPart)
Debug.Print TypeName(mrg)
If Not mrg Is Nothing Then
firstaddress = mrg.Address
Set alladdress = mrg
Do
Set mrg = .FindNext(mrg)
Set alladdress = Union(alladdress, mrg)
Loop While mrg.Address <> firstaddress
End If
alladdress.Select
End With