case insensitive

  1. J

    Case insensitive

    Can anybody help me? Example: I want the word "the" it must be able to copy any word with "the" inside. Like, These, tHEsE, ThE, thEresa would be copied. The code looks like this.. Sub NonSensitive() Dim rCell As Range For iCntr = 1 To 30 For Each rCell In Range("I1:I10")...
  2. J

    Campore 2 cells (want non-case sensitive)

    Hello, I have data set up on 2 sheets (each cell similar to 12345MD, and right now I am using an If statement like this: If Cell1 = Cell2 Then Do stuff This requires the text in each cell to be an EXACT match. I would like to be able to have the condition return true regardless of case...
  3. A

    Current UDF - Compare two text strings make not case senstive

    I use these two UDFS to find the differences between two strings of text, i would be great if they were case insensitive. If anyone knows how to change these ones or has a better UDF for comparing two text strings ( like with options for choosing different / multiple seperators etc that would...
  4. A

    Replace Name with Unique ID in a List of participants

    Hi - I have a 1000+ list of participants and their organizations. I want to replace the value i column B with the Unique ID in column D, IF and only IF it is a match between column B and column C: I´ve two problems: 1) My VBA-code is case sensitive which is wrong. Should be => case...
  5. K

    Case Insensitive Search

    I have the code below that takes the user input from a text box "strtraveler" (a traveler number typicall looks like 12345p678and finds what the user inputs on the sheet and moves it to another area then deletes it from its previous area. This is case sensitive and I don't want it to be...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top