VBA problem..

[Sipsoo]

Hi,

Getting really desperate and need some serious help.

I am busy trying to write a macro that will enable me to input a month and year i.e aug 2006, it then sets up the spreadsheet as follows..

Tue
Thur
Fri
Sun


Tue
Thur
Fri
Sun


Tue
Thur
Fri
Sun


Tue
Thur
Fri
Sun


Tue
Thur
Fri
Sun

What I am trying to do it is populate the cells next to the days with the date i.e.

Tue 5/09
Thur 7/09
Fri 8/09
Sun 10/09

Tue 12/09
Thur 14/09
Fri 15/09
Sun 17/09

etc.

Is this possible??

Best regards,

Ken

 

[Peter_SSs]

Sipsoo

Does it need to be a macro? Is this formula approach any use?

Post back if you have any interest in this but modifications are needed.

E3: =DATE(E2,E1+1,1)-1
Individual formula in B2:B4
Formula in B7 copied down to B10
B7:B10 block copied down to the other blocks.

Mr Excel.xls
	A	B	C	D	E	F
1	Tue	Tuesday, 5 September 2006		Month	8
2	Thur	Thursday, 7 September 2006		Year	2006
3	Fri	Friday, 8 September 2006		Start Date	31/08/2006
4	Sun	Sunday, 10 September 2006
5
6
7	Tue	Tuesday, 12 September 2006
8	Thur	Thursday, 14 September 2006
9	Fri	Friday, 15 September 2006
10	Sun	Sunday, 17 September 2006
11
12
13	Tue	Tuesday, 19 September 2006
14	Thur	Thursday, 21 September 2006
15	Fri	Friday, 22 September 2006
16	Sun	Sunday, 24 September 2006
17
18
19	Tue	Tuesday, 26 September 2006
20	Thur	Thursday, 28 September 2006
21	Fri	Friday, 29 September 2006
22	Sun	Sunday, 1 October 2006
23
24
25	Tue	Tuesday, 3 October 2006
26	Thur	Thursday, 5 October 2006
27	Fri	Friday, 6 October 2006
28	Sun	Sunday, 8 October 2006
29
Dates

 

[Sipsoo]

Hi,

Thanks for the formular but I would prefer a macro as the rest of my sheets are macro based.

Regards,

Ken