"Worksheet Change" Question
 

I am using the following code to run a macro if the data
in this cell (E26) is changed. I want another cell on
the same worksheet to do the same thing. (E28). I tried
adding another "worksheet change" but it didn't like it,
evidently you can only have one per sheet. How do I add
the other cell into the mix? Thanks

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("E26")) Is Nothing Then
Sheets("Entry").Select
Application.Run "CopyFilterData5"
End If
End Sub

"Worksheet Change" Question
 

Mike,

Try this

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("E26,E28")) Is Nothing Then
Sheets("Entry").Select
Application.Run "CopyFilterData5"
End If
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"documike" wrote in message
...
I am using the following code to run a macro if the data
in this cell (E26) is changed. I want another cell on
the same worksheet to do the same thing. (E28). I tried
adding another "worksheet change" but it didn't like it,
evidently you can only have one per sheet. How do I add
the other cell into the mix? Thanks

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("E26")) Is Nothing Then
Sheets("Entry").Select
Application.Run "CopyFilterData5"
End If
End Sub