Results 1 to 2 of 2
Thread: Macro Compare Case Insensitive
2001-04-13, 19:34 #1snax500Guest
Macro Compare Case Insensitive
In Excel2000, I have the following code in my macro:
If rng Like rng4 Then
the problem is that I need this comparison to be case insensitive. How do I alter this, so that "Yes" = "yes"
2001-04-13, 20:29 #2
- Join Date
- Jan 2001
- Kortrijk, Belgium
- Thanked 0 Times in 0 Posts
Re: Macro Compare Case Insensitive
if you want it to be case insensitive you can do something like
if UCase(rng) like UCase(rng4) then
The UCase function is equivalent to the UPPER function in Excel and turns all characters to uppercase.