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

Take a look at http://xldynamic.com/source/xld.CF.html#calendar

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"San" wrote in message
ups.com...
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

I can't seem to make the codes from the site to work! it just say wrong
formula even though I just copy paste.
I have my date format as (dddd-dd-mm) from A9:A39 and A44-A71 and so
on. Between A39 and A44 is just where I sum up some data.

pls help




Bob Phillips skrev:
Take a look at http://xldynamic.com/source/xld.CF.html#calendar

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"San" wrote in message
ups.com...
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

I need more info than that to work on as I know that the example does work.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"San" wrote in message
ups.com...
I can't seem to make the codes from the site to work! it just say wrong
formula even though I just copy paste.
I have my date format as (dddd-dd-mm) from A9:A39 and A44-A71 and so
on. Between A39 and A44 is just where I sum up some data.

pls help




Bob Phillips skrev:
Take a look at http://xldynamic.com/source/xld.CF.html#calendar

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"San" wrote in message
ups.com...
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