Hello,
I have an If x = y Then statement that compares two string variables, whose values were obtained from the values of two cells in a spreadsheet. Apparently, this is a case sensitive comparison, because the statement is false when the contents of one variable include capital letters and those of the other do not, even if the letters are the same (i.e. Jim and jim)
I'd like the statement in these cases to be true, so therefore I must make it not case sensitive. Is there a way to do this?
Thanks!
I have an If x = y Then statement that compares two string variables, whose values were obtained from the values of two cells in a spreadsheet. Apparently, this is a case sensitive comparison, because the statement is false when the contents of one variable include capital letters and those of the other do not, even if the letters are the same (i.e. Jim and jim)
I'd like the statement in these cases to be true, so therefore I must make it not case sensitive. Is there a way to do this?
Thanks!