Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, [A1]) Is Nothing Then _
With Sheets("02"): .PageSetup.RightHeader = [A1].Text: .Activate: End With
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [A1:A2]) Is Nothing Then Exit Sub
With Feuil2
.PageSetup.RightHeader = [A1].Text
.PageSetup.CenterHeader = [A2].Text
.Activate
End With
End Sub