I am trying to run a macro that checks to see if an increment has increased above and threshold and then increment another value. I want to implement:
But when I run the macro with a value less than 12 it still runs as if the statement was TRUE and completes the increment. The only way that I can get it to run is to go with:Sub Month_Chg() Range("c2").Select If (Selection.Value > "12") Then Range("A2").Select Selection.Value = Selection.Value + 1 End If
What I am doing wrong?Sub Month_Chg() Range("c2").Select If (Selection.Value = "13") Then Range("A2").Select Selection.Value = Selection.Value + 1 End If
Thanks,
Dave
Bookmarks