Excel Macro Using "Like" comparison
Disregard the last one, I hit post in error.
"JLGWhiz" wrote in message
...
Make the comparison in the same case like this:
If LCase(Cells(x, 3).Value) Like "ss = true" Then Check = "True"
- where SS is - SS = Range("E12") & "*"
"jswalsh33" wrote:
I have found it convenient to use a macro code such as - If Cells(x, 3)
Like
SS = True Then Check = "True"- where SS is - SS = Range("E12") & "*".
I find that this comparison is case sensitive, which is inconvenient for
my
purposes. Is there a way of making this process insensitive to case with
this
macro code or some other code?
Jim Walsh
|