Hi all,

i am trying to make use of the target in worksheet change event but only when a single cell is change.

problem is that even when the cell is changed it's not going through my if statement.

here's what i have...
If Target.Address = Range("$B$2") Then
MsgBox "hello"
End If
...but even when the cell B2 is changed it doesn't trigger the message box.

Also, ideally i'd like to change B2 to a named range but i couldn't figure it out?? can anyone help.

thanks