referencing the current month in a heading

[ericpny2]

I have a ton of sheets within a workbook that alll have a heading with the date and other information at the top.

i have used "[tab]" in the heading to fill that area with the name of the tab.

Is there a similar command to fill in the current month?
I tried [month] and also tried referencing a specific cell that contained the month, but i have had no luck. please let me know

Thanks

 

[ericpny2]

(The Company Name)
(Job number)
"Weather Conditions for August 2011"

All of that goes into the center header
Weather conditions is the name of that tab and that is where i used the &[tab]

 

[VoG]

Try like this

ActiveSheet.PageSetup.CenterHeader = "Company Name 0001 & Weather conditions for " & Format(Date, "mmmm")

If you need variables for some of this you will need to tell us exactly where they are.