Is it possible for VBA to check which cell is active?
If the active cell is A9 I want to fire off another procedure other just carry on with code.
I thought the following would have worked
Thanks
If the active cell is A9 I want to fire off another procedure other just carry on with code.
I thought the following would have worked
Code:
If Range(ActiveCell) = Range("A9") Then
MsgBox ("Range A9")
Else
MsgBox ("Range not A9")
End If
Thanks