Matching string in an array of strings

[vientito]

I am looking to find a matching word on an array of string. At first I was thinking of using array function filter to do the job but soon realized that it is case-sensitive operation and it does not suit my needs.

now I am thinking of two ways to achieve what I want to do

(a) use an old fashioned looping operation where I first lowercase cast the string and do an instr to determine if there is a match
(b)assign the array on a worksheet to form a range then use range.find & range.findnext to get all occurrence of the looked-for pattern

Which way would probably come out faster & are there any other way that would be more efficient than working with a looping operation?

It would be ideal to have case-insensitive filter function but unfortunately that does not exist at all

[watersev]

hi vientino, a couple of thoughts on the issue:
1. Filter function: match = word and match=Word if this way is suitable
2. Use regular expressions pattern with ignorecase property set to true
3. Use range find method that have Matchcase option
4. Use autofiler on a worksheet (ignores cases)

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.