VBA Print Headder

[cmschmitz24]

Hello,

I want to have a header print out based on the current month/year with the worksheet tab and "transactions" included.

I've tried this,
.CenterHeader = "&A &D Transactions"

I currently have this, but I cannot figure out how to add the word Transactions, or the worksheet tab name.
.CenterHeader = Format(Now, "MMM YYYY")

I only want the current month and the current year, not the actual date.
The header should read: TabName February 2018 Transactions

Can someone help please?

 

[Tetra201]

Try

.CenterHeader = "&A " & Format(Date, "mmmm yyyy ""Transactions""")

 

[cmschmitz24]

How simple was that! Lol thanks!! Works perfect

 

[Tetra201]

You are welcome.

Please note, however, that the date will NOT update automatically because "February 2018" is added to the header as a text string.