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

 

[Jonmo1]

Sorry, I don't understand this statement

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

What is "[tab]"


To get the current month, try

=TEXT(TODAY(),"mmmm")

 

[VoG]

You would need code for that I think

Sub test()
ActiveSheet.PageSetup.CenterHeader = Format(Date, "mmmm")
End Sub

 

[ericpny2]

[tab] enters the name of the tab. keep in mind this is in a header of the worksheet. if you go to view>page layout, you can see the header there. it is not going into a specific cell. it is more like a microsoft word format

 

[ericpny2]

You would need code for that I think

Sub test()
ActiveSheet.PageSetup.CenterHeader = Format(Date, "mmmm")
End Sub

The problem with that code is that it replaces all of the other information in the header and only puts the month


ALSO: i had it wrong. the function is actually &[tab] and that puts the name of the tab in that postition

 

[ericpny2]

lets forget about the month referencing. is there anyway to reference cell A1 in the header so that is reads the contents in that cell?

 

[VoG]

The problem with that code is that it replaces all of the other information in the header and only puts the month


ALSO: i had it wrong. the function is actually &[tab] and that puts the name of the tab in that postition

Are you saying that it replaces the left header and the right header as well? I find that diffuicult to believe.

 

[VoG]

lets forget about the month referencing. is there anyway to reference cell A1 in the header so that is reads the contents in that cell?

I think that you would need code for that as well.

 

[ericpny2]

Are you saying that it replaces the left header and the right header as well? I find that diffuicult to believe.

No it is not replacing the right and left header, but all of my information is in the center header and the month is needed in the middle of a sentence in the middle header.

it sounds like this requires a code. thanks for your help

 

[VoG]

What should your sentence be?