Oh, I see what you mean now. You can cycle through all your sheets like this:
cheers,![]()
Sub CellInHeader() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets With ws .PageSetup.CenterHeader = "Annual Report " & ActiveWorkbook.Sheets("Sheet4").Range("=A20").Text End With Next End Sub
Bookmarks