Private Sub Worksheet_Change(ByVal Target As Range)

Specifying Target Not Working...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("i4_Disc") Then
Msgbox �Cell D11 has changed.�
End If
End Sub

Thanks,
Arturo

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$D$11" Then
Msgbox “Cell D11 has changed.”
End If

http://www.cpearson.com/excel/events.htm

d'oh!

"Arturo" wrote:

> Specifying Target Not Working...
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Address = Range("i4_Disc") Then
> Msgbox “Cell D11 has changed.”
> End If
> End Sub
>
> Thanks,
> Arturo
>
>