If Target.Address = "$A$4" Then

or
If Target.Address(0,0) = "A4" Then

--
Regards,
Tom Ogilvy


"dave!!" wrote in message
...
I have a data validation list with a number of states in it. Each time I
select a new state I want 2 macros to run. The list is in cell A4 of
Sheet
1. Here is the code I am using at the worksheet level, can someone tell
me
what I'm doing wrong?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "A4" Then
pp_maj_macro
pp_minor_macro
End If
End Sub

Thanks so much,
Dave