CODEWITHSUNDEEP
excelvba
lererferler
lererferler

Reputation: 59

Search for "*" using VBA

Does anybody know how to search for the wildcard character "*" using the Range.Find method and make it search for the character rather than a wildcard?

Upvotes: 0

Views: 60

Answers (2)

Gary's Student
Gary's Student

Reputation: 96753

Consider:

Sub SearchingforStars()
    Cells.Find(What:="~*", After:=Cells(1)).Select
End Sub

Tilda is your friend!

Upvotes: 2

Amen Jlili
Amen Jlili

Reputation: 1934

Try this string with Range.Find:

"~*~"

Upvotes: 1

Related Questions