+ Reply to Thread
Results 1 to 3 of 3

Use Like to Find a String that is Case Insensitive

  1. #1
    Registered User
    Join Date
    10-03-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    44

    Use Like to Find a String that is Case Insensitive

    Hi All,

    I am trying to create a loop that checks each cells' value in the designated range and if it contains "XYZ" then execute the code provided. I want the code to read "XYZ" as insensitive, not match exactly "XYZ", but be able to match "xyz" ,"XyZ", etc.

    Here's an example:

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: Use Like to Find a String that is Case Insensitive

    Try this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    10-03-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: Use Like to Find a String that is Case Insensitive

    That worked perfectly. That is exactly where I was having difficulty in how to fit the UCase into the coding.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find word(s) within text string that matches a list of keywords - NOT case sensitive
    By gbm222 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2013, 02:15 AM
  2. How to make case insensitive within a MACRO
    By andreadouglas26 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-05-2012, 01:16 PM
  3. Find (case and diacritics insensitive) duplicates in one column
    By greek in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2011, 04:00 AM
  4. Case insensitive search for string within folder of excel files
    By vba_novice in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-22-2011, 11:21 PM
  5. [SOLVED] VBA and Case Insensitive
    By robin.coe@gmacinsurance.com in forum Excel General
    Replies: 2
    Last Post: 03-09-2006, 01:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1