| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Current year and current week number | Excel Discussion (Misc queries) | |||
| Always show Jan of current year | Excel Worksheet Functions | |||
| use current year in macro | Excel Discussion (Misc queries) | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
![Raman325[_37_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
