I have date placed in alternate cells for example A1-01/03/05
C1-02/03/05 D1-03/03/05 F1-04/03/05 till ....30/03/05


What I do is fill up these cells manually for every month, basically by
copying
the last months dates into a new worksheet and changing it for the new
month.


Is there a way where i could input a start date and end date on a
particular cell or in dialog box and then execute a macro to fill up
alternate cells for the given range...


Appreciate any help.


Thanks.


Praz