Matching macro ignores ALL CAPS, finds no match.

[taylorsm]

If I have the name on the list of filenames as "George, King" and the source sheet as KING GEORGE then it will fail to find and export. but if I change the source sheet to King George then it will find it just fine. I know there are not any trailing spaces or anything as I have retyped the word to make sure.

How do I get it to ignore the case?

Please Login or Register  to view this content.

[taylorsm]

Option Compare Text seems to have done it. Anything better?

[Fluff13]

Another option is to add the final parameter to the Instr like

Please Login or Register  to view this content.

[taylorsm]

Is there a benefit in going that route?

[Fluff13]

Possibly
If you run Option Compare Text, then that will affect all macros in that module.
If you only have the 1 macro then no problem, but if you have other macros in that module then it may cause problems, depending on what the other macro(s) are doing.

[taylorsm]

Gotcha. Thanks!