CALENDAR Macro autofill with two extensions

[lewis1]

Hi,

I would like a macro that performs the following, however I don't really know where to start.

The macro should...

1. Autofill dates from the Start Date ("D5") for x amount of years. Autofill begins in Range("C10")
2. Point out the THIRD 'wednesday' of every month with a "1" in column D.
3. Point out the second last 'weekday' of every month with a "1"in column E.

Is this something anyone can help with, realize it might be too much

Thanks,
Lewis.

 

[DeusXv]

Just post the last two parts in the same thread, as your first Q, as it's just a small bit extra that you already need to add to existing code:

http://www.mrexcel.com/forum/excel-...tofill-dates-between-start-date-end-date.html

 

[lewis1]

ok thanks

 

[DeusXv]

ok thanks

No problem and I'm sure the question will be answered quicker due to the fact that there are already a few people helping you out in the other thread.