Hey Juan,

By "Page Header" do you mean the Header/Footer section in the Page
Setup? If so, try this:


For Each Sh In ActiveWorkbook.Worksheets
Msg = InputBox("What month?")
Sh.PageSetup.CenterFooter = "Total Items - Period " & Msg & ",
2007 YTD"
Next Sh


On Jan 8, 4:28*pm, Juan wrote:
Hello,
I have about 6 sheets and each has a Page Header
Example,
Total Items - Period X, 2007 YTD, I'm trying to input an actual number in
the X,
Example, Total items - Period 12 2007 YTD. *Its time consuming going
manually into each sheet an replace the X with the current Period.
Is there a way I can do this with a Macro? *

I really would appreciate any info I can get
Thank you,
J