Get Current Year

[Raman325]

Hi,

I'm writing a macro that edits the footer, and as part of the footer, I wanted to include the current year, preferably as a variable. If possible, what is the variable I can use to get the year, and if not, is ther another solution? Thanks.

Raman

[Trevor Shuttleworth]

Raman

Dim iYear as Integer
iYear = Year(Now)

Regards

Trevor


"Raman325" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I'm writing a macro that edits the footer, and as part of the footer, I
> wanted to include the current year, preferably as a variable. If
> possible, what is the variable I can use to get the year, and if not,
> is ther another solution? Thanks.
>
> Raman
>
>
> --
> Raman325
> ------------------------------------------------------------------------
> Raman325's Profile:
> http://www.excelforum.com/member.php...o&userid=24748
> View this thread: http://www.excelforum.com/showthread...hreadid=542655
>