Return the range of active cell

[mikeymay]

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

If Range(ActiveCell) = Range("A9") Then
    MsgBox ("Range A9")
    Else
    MsgBox ("Range not A9")
End If

Thanks

 

[DominicB]

Good afternoon mikeymay

How about :

If ActiveCell.Address = "$A$9" Then
    MsgBox ("Range A9")
    Else
    MsgBox ("Range not A9")
End If

HTH

DominicB

 

[sykes]

Hi

Try:

Sub HF()
If ActiveCell.Address(rowabsolute, columnabsolute) = "A9" Then
MsgBox "Yeeeessssss"
Else
MsgBox "Nope"
End If
End Sub