Searches using Find with wildcard

E

excelnut1954

The code below will search for a records based on user entry. It uses
the wildcard at the end.
Is there an adjustment to the code below that will limit the wildcard
to just letters?

Set rngToSearch = Sheets("Official List").Range("POCurrent_Column")
Set rngFound = rngToSearch.Find(What:=FindPOVal & "*", _
LookIn:=xlValues, _
LookAt:=xlWhole)


Thanks
J.O.
 
J

Jay Freedman

Try asking in the newsgroup microsoft.public.excel.programming. This
newsgroup is for Word, which has a very different search mechanism.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help w/ current Find macro so it will recognize possible trailing letters 1
Find macro with wildcard as part of code 2
Wrong Row Selected 11
Find next problem 1
FindPrevious - will not step back to the original Find. 5
Test variable range for 'Delete'; then delete the row 2
Search wildcard to limit only alpha characters 2
How do I get this macro to start the search in the second row 2

Top