How to find the current year in vba

[dpaton05]

What is the vba code to find the current year?

 

[dpaton05]

The top of each sheet is to look like this: https://www.screencast.com/t/hYwCt23ki

I can get it all looking right except the year. I don't know how to get the current year at the end of the various strings.

 

[My Aswer Is This]

Several of us have provided answers: And you never answered my question

To get current year you use: Year(Date)

Anytime you use Date You get todays date you do not need to use Now

 

[RoryA]

You can add a function rather than sub:

Function CurrentYear() As Long
    CurrentYear = Year(Now)
End Function

then just use CurrentYear wherever you need the year.

 

[dpaton05]

Where do I put this function? Do I need to put the code in some initialise procedure.

 

[Michael M]

Function has to be placed in a standard module.
So, in the VBA toolbar>> Insert>>Module

 

[dpaton05]

Several of us have provided answers: And you never answered my question

Sorry I never got to responding to you.