Two condition If statement

[Yoepy]

Please can someone tell me why this doesn't work?
RepeatPublish is a named range on another sheet which has the value "Yes" in it.

It works without the the second test.

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Application.Intersect(Target, Range("C:P")) Is Nothing Then
    If Target = "Win" Then
        If Range("RepeatPublish") = "Yes" Then
            MsgBox "Working", vbInformation, "Scoring"
        End If
    End If
End If


End Sub

Regards Yoepy

 

[Yoepy]

It would appear I can't run the test on a range from another worksheet. Is that correct?

    If Target = "Winner" And Range("A1") = "Yes" Then

This works when I reference "RepeatPublish" on the active worksheet.