+ Reply to Thread
Results 1 to 2 of 2

Change macro to case in-sensitive.

  1. #1
    Registered User
    Join Date
    02-14-2008
    Posts
    22

    Change macro to case in-sensitive.

    Hi,

    I posted a question a while ago about searching a column with values to check whether they were found in another column.

    Someone helped me out there, and the code is absolutely perfect, except for this minor detail. I need a case in-sensitive search, whereas the way it is coded now, it is case sensitive. So if I search for value 1, or Value 1 is should give the exact same result. Here is the post on the forum with his solution:
    http://www.excelforum.com/showthread.php?t=635063

    I uploaded the file with the macro and an example. I also included te VBA code. Pointing out where the case sensitive thing is encoded is also much appreciated.

    exampleNew.xls.zip

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    This should help you work it out (i haven't looked at your file!)
    Please Login or Register  to view this content.
    Not all forums are the same - seek and you shall find

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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