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:
Sub Month_Chg()
Range("c2").Select
If (Selection.Value > "12") Then
Range("A2").Select
Selection.Value = Selection.Value + 1
End If
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 = "13") Then
Range("A2").Select
Selection.Value = Selection.Value + 1
End If
What I am doing wrong?
Thanks,
Dave
Bookmarks