Incercati:
Cod: Selectaţi tot
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, ActiveSheet.Range("f3:f4")) Is Nothing Then
If Target.Columns.Count > 1 Then Exit Sub
If Target = Range("F3") Then Target.Offset(1, 0).Value = ""
If Target = Range("F4") Then
ActiveSheet.PageSetup.CenterFooter = "&""Arial,Bold""&20" & Target.Value
Sheets("Sheet3").PageSetup.CenterFooter = "&""Arial,Bold""&20" & Target.Value
End If
End If
End Sub