ActiveCell = address

[Maurizio]

How can I write a formula that:
if activecell has address "C1" then...
Cells(550, 2).End(xlUp).Select

 

[Joe Was]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Sheet Module code.
'Trigger if selected cell is "C1."
If Target = [C1] Then

MsgBox "Test Message!" '<== Put your code in place of this!

End If
End Sub

Hope this helps. JSW

 

[Chas17]

This works, however, If you select a row by clicking on row #, say row 5, it will error.
Excell 97.

 

[Joe Was]

This is a better macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim myCell As Range
'Sheet Module code.
'Trigger if selected cell is "C1."
Set myCell = Range("C1")
If Target.Address = myCell.Address Then

MsgBox "Test Message! " '<== Put your code in place of this!

Else
Exit Sub
End If
End Sub