I just added the code...
Before lunch it worked fine. Now I've come back and it wont work I put a 1 in cell A1 and nothing happens. If I record a macro and run it, it works, but the macro above just wont work even though an hour ago it worked fine. I've not changed what I type in and macros are enabled.
Its very frustrating!! lol
Any ideas?
Cheers.
Code:
If Target.Address = "$A$1" Then
Application.EnableEvents = False
If Target.Value = 1 Then
Range("A1").Value = "Hello world"
Else
Range("F10").Value = ""
End If
Application.EnableEvents = True
End If
Before lunch it worked fine. Now I've come back and it wont work I put a 1 in cell A1 and nothing happens. If I record a macro and run it, it works, but the macro above just wont work even though an hour ago it worked fine. I've not changed what I type in and macros are enabled.
Its very frustrating!! lol
Any ideas?
Cheers.