VBA Code for Uppercase or Lowercase letters

I have code written to find certain text in column "Y", and return a value if it finds it. Sometimes the text I'm looking for is in uppercase letters and sometimes it is in lower case letters, although it's the same word. As you can see in this example, I currently have 2 code lines to find all the text. One line is searching for the test in upper case and one is to search the code in lower case. The code works fine, but it seems there should be code that looks for the text whether it's in upper or lower case. As you can see, first I search for all text containing "*TW Synergy*", and then I search for all text "*TW SYNERGY*". I would like to find code that looks for "Synergy" whether its in upper case or lower case and return the value ""Interconnect".

Please Login or Register  to view this content.

Can you help?
Greg

Thanks PCI. This is what I did and it's doing what I need it to do now. Thanks.

Thanks Ron. I went another direction and am working now. Thanks again for your reply.