Wildcard macro that isn't case sensitive

[boomboomblock]

I have a wildcard that changes some shortened down words to their proper spelling. However I have another sheet where the same words are in capitals. Is there any way for my macro to search through the words so that they aren't case sensitive?

Please Login or Register  to view this content.

[NickyC]

it's a bit fiddly to change all your lines but something like this should work

Please Login or Register  to view this content.

[boomboomblock]

Thanks for that, much appreciated

[apo]

Hi..

Try adding this line above your Sub..

Option Compare Text

http://msdn.microsoft.com/en-us/library/8t3khw5f.aspx