Comparing cells question

[SvenVII]

I've written a macro the compares the contents of two cells. My issues is that if the 2 cells contain the same information, but one is just in uppercase it says that the two cells are not equal. How can I write the code so that when the contents of the 2 cells contain the same informatio regardless of being uppercase or not, it returns that they are equal?

 

[Ruddles]

Option 1: turn them both into UCASE() or LCASE() before comparing them, so instead of:-

If Range("A1").Value=Range("X99").Value Then...

you do:-

If UCase(Range("A1"))=UCase(Range("X99")) Then...

Option 2: Head your code module with the compiler directive Option Compare Text which will make all text comparisons in the module non-case-sensitive.

 

[SvenVII]

Wow, thank you very much.