AutoFill cell from above macro

I am looking for a macro that will be able to autofill until it reaches a different value. Once it hits that value can it then autofill until the next value and so on?

Example:

A1 Cell : 10/10/2007
A2-A50 are blank

A51: 10/11/2007
A52 - A103 are blank

The problem is that the number of cells between each of the dates varies. Is there a macro that can be created that will autofill the date (so it would autofill 10/10/2007 until it reaches 10/11/2007, then it would autofill from 10/11/2007 until 10/12/2007 and so on). Any help with this would be appreciated. Thanks for your time.

That is perfect. One question though is there a way to have this autofill to a certain cell number. The code ends at the last date, can this be autofilled farther than that to say a specific cell #?

Maybe a better example is that the last date is on 10/15 and it autofills to that date. Can I change the code to autofill to a specific cell past that date.

Example:

A1500 - 10/15
A1501 - 1600 are blank

Can we set the code to fill to cell A1600 instead of stopping at A1500?

You rock that is perfect. Thanks again!