Can somebody possibly tell me what is wrong with this simple code?
Code
Sub CrankTooMuch()
If CrankLevel < 6 Then
Application.Run "CrankDown"
Else
Application.Run "CrankUp"
End If
End Sub
Display More
It should run the CrankUp macro if the cell named CrankLevel is equal to 6, and run the CrankDown macro if it is less.
The crankUp and CrankDown macros apply a one-off formatting change, and remove it respectively.
Thanks in advance,
Mike