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 Range)
 

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