Results 1 to 9 of 9

Not differentiating between capital letters and lower case letters

Threaded View

  1. #1
    Registered User
    Join Date
    12-25-2014
    Location
    Jerusalem
    MS-Off Ver
    XP
    Posts
    23

    Not differentiating between capital letters and lower case letters

    Hi,

    I would like to know how I can make it so the equation on VBA doesn't differentiate between capitals letters and lower case. For the example below, I have had to put the conditions twice in order to include both capitals and lower case.

    If Len(title) > length Then
    title = Replace(title, "size", "")
    title = Replace(title, "Size", "")
    title = Replace(title, "height", "")
    title = Replace(title, "Height", "")
    End If
    Many thanks in advance for any help.
    Last edited by Eliot Y; 03-22-2015 at 06:47 AM.

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