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.
Jay Freedman - 22 Sep 2006 16:29 GMT
Try asking in the newsgroup microsoft.public.excel.programming. This
newsgroup is for Word, which has a very different search mechanism.

Signature
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
> The code below will search for a records based on user entry. It uses
> the wildcard at the end.
[quoted text clipped - 8 lines]
> Thanks
> J.O.