Change Macro to make calendar in excel

[abjac]

Hi i have below code, which i have found online to create a monthly calandar with a macro.

I need some few changes, have been playing with it , but cant make it work.

First i need to change so it start with Monday instead of Sunday.
Second i need to make so i can make a complete year calandar in the same sheet.
So if i use this code. it example paste the first month in from example January 2013

When i run the code again i choose February. And it paste the monthly calendar in the same sheet, but with example 2 empty rows between.

In this case i can make a year calandar in the the same sheet. If the code can be done, so it do it in one run, its off course perfect, but if no, its ok that i have to run it 12 times. Most important is that i make the monthly calendar in the same sheet, and that it change first day to a Monday.

Please have a look at the code and also you can play with it in the attached test xls.

Thanks

Sincerely

Abjac

The code.

Please Login or Register  to view this content.

[HaHoBe]

Hi, abjac,

it would have been easier to write a new procedure as to rewrite the one supplied here. I wonder where and why you find these kind of codes (I can state the original is not by me - I hardly comment the code ).

Please Login or Register  to view this content.

Adjust the lines between the first row for each month in the constant clngNEW_ROW at the beginning of the code (right now it is set to 15).

Ciao,
Holger

[abjac]

HI Holger. Thanks yes i was looking after this code and it was shown in a microsoft page. And infact the only one i could find, doing this. So i did not have so much choice. Your code Holger is just perfect. Its really a great code. You are a magician with these codes. So what can i say, thanks allot. I will use this code for a project, where i will make a planning calender, week by week. And with notifications. So this is the first step. So thanks have a nice day there.

Sincerely

Abjac