+ Reply to Thread
Results 1 to 4 of 4

Macro NOT case sensitive

  1. #1
    Forum Contributor
    Join Date
    09-25-2012
    Location
    Ventura, united States
    MS-Off Ver
    Excel 2010
    Posts
    346

    Macro NOT case sensitive

    I've been using this macro to hide all but the columns I need. It references the column headers to see if the name is one of the ones below. The bastards that make this spreadsheet just decided to us CAPS on everything and now the macro doesn't recognize any of the names. It will probably be lowercase again next time, so is there any way to easily make it recognize lower or upper case???



    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Macro NOT case sensitive

    Add one line on top of the Module
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-25-2012
    Location
    Ventura, united States
    MS-Off Ver
    Excel 2010
    Posts
    346

    Re: Macro NOT case sensitive

    Yes!!!!!!!!!!!!

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Macro NOT case sensitive

    Another way:

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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