Is there a function or macro to update calendar in a way tha it runs through
the whole row automatially upon a click of a button, I need the different
months to appear on different worksheets. Dragging through the cells every
end of the month is too time-consuming.

e.g. 1st row 28 oct 07 29 oct 07 30 oct 07
2nd row Sunday Monday Tuesday

Will the calendar control object in Excel help in that?

Thanks in advance