Get Current Year
 

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

Get Current Year
 

Raman

Dim iYear as Integer
iYear = Year(Now)

Regards

Trevor


"Raman325" wrote in
message ...

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