excel vba to paste range of dates

[Gourav]

Hi,

I want to paste range of dates in excel cell. So lets says, i provide my input as
Start date - 01/01/2013
End date - 01/20/2013

So, my vba should calculate the dates, and paste from 01/01/2013, 01/02/2013,01/03/2013....01/20/2013. Also, i would like to find the days whether it is a sunday or monday. In case it is sunday or saturday, i would like to color code that cell.

[berlan]

Hi Gourav, try this (see attached as an example):

Please Login or Register  to view this content.

Cheers, berlan

[xladept]

Hi Gourav,

Here's a start:

Please Login or Register  to view this content.

[Gourav]

hi berlan this looks good.
Only couple of things.

a) can u transpose while pasting the date
b) can you add day as well on top of the date

[Gourav]

hi berlan this looks good.
Only couple of things.

a) can u transpose while pasting the date
b) can you add day as well on top of the date