Show month in header

[dprobst]

Is there a way (function or formula) to display only the current month in the header? I know I can display the current date, but I need it to display only the current month. Thanks.

[stephenloky]

=month(now())

[dprobst]

That works in the spreadsheet, but when I try to put it in the header all it shows is the formula, not the result.

[stephenloky]

What header do you mean? I don't get it

[dprobst]

The header - click INSERT tab at the top, click HEADER & FOOTER on the TEXT toolbox. Click to add header. This is where I want to have the current month displayed.

[stephenloky]

Sub foo()

With ActiveSheet.PageSetup
    .LeftHeader = Format(Now, "MMM")
End With

End Sub

Should do the trick.

[dprobst]

This works fine, thanks.