R
richzip
I have a worksheet set up, along with a macro. It changes the value of
column G, but only if column T does not contain the letter "N". If column T
DOES contain the letter "N", then column G is unchanged
The code below only works if the letter N is uppercase. I want to change to
code to look for both uppercase and lower case "N".
If .Cells(X, "G").Value > 0 And .Cells(X, "G").Value < 0.1458333 And
..Cells(X, "T") <> "N" Then .Cells(X, "G").Value = "3:30"
column G, but only if column T does not contain the letter "N". If column T
DOES contain the letter "N", then column G is unchanged
The code below only works if the letter N is uppercase. I want to change to
code to look for both uppercase and lower case "N".
If .Cells(X, "G").Value > 0 And .Cells(X, "G").Value < 0.1458333 And
..Cells(X, "T") <> "N" Then .Cells(X, "G").Value = "3:30"