If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
Try this:
Sub checkA()
If (ActiveCell.Address(False, False) = "D2") Then
MsgBox "You reach D2"
Else
MsgBox "You are at " & ActiveCell.Address & ""
End If