Through the use of an Excel macro If Statement, I want to be able to analyze the current cell position and depending on the cell position have the macro move the cursor. This is the statement that I wrote but does not seem to work. It skips to the end if and does not perform the command.


If ActiveCell = "$A$2" Then
'Application.Goto Reference:="R10C1"
End If