| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calendar year change.
Hi
I have a calendar with everyday from "Sunday 1 Jan 2006" To "Sunday 31 Dec 2006". I need to make a macro that when it is run it will change the year from 2006 To 2007. Another thing is that I want saturday and sunday to be marked(say green) But when the year changes the dates are push forward so now it is sunday and monday that is marked. How to make it auto mark saturnday and sunday again? It would be nice to have it all in one macro thanks San |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calendar year versus fiscal year | Excel Discussion (Misc queries) | |||
| Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
| change the calendar to reflect the current year | Excel Worksheet Functions | |||
| change the calendar to reflect the current year | Excel Worksheet Functions | |||
| change the year in a calendar template to different year | Excel Discussion (Misc queries) | |||
![San[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
