Code not working with an input Captial letter

[wagmanm]

I have code that I just noticed will not work if user inputs a capital S. I have tried a few things but I can not seem to get it to work.
Here was the original code:
If Range("H13") <> "s" Then

I tired this:
If Range("H13") <> "s" or "S" Then

I'm sure there must be an easy way to do this can anyone help me?

 

[JoeMo]

Try:
If LCase(Range("H13")) <> "s" Then

 

[L. Howard]

One way is to place this statement Option Compare Text at the very top of the module the code is in, right below or above Option Explicit if you are using that also.


Regards,
Howard

 

[bruderbell]

The syntax for OR requires that use a full expression on each side of the OR. So you might have tried

<code>If Range("H13") = "s" Or Range("H13") = "S" Then
else
'here is your code
end if</code>

But that isn't as clean as what's already been proposed. Just saying, you weren't necessarily on a dead end trying to use OR