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...