View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Singmin Michael Singmin is offline
external usenet poster
 
Posts: 60
Default Filesearch with disregard of Case

Hello group,

I am using Application.Filsearch to look for text
I want the Filesearch not to look at Case.
So Cat, cAT and caT will be found if .TextOrProperty = "Cat"
I have set .MatchTextExactly = False

But something is still not right because only Cat is found.

Any insights ?

Michael Singmin