Hi all,

trying to write a macro to do the following.

I have a column dates and blanks cells in between;

Oct 05


Nov 05


Dec05

I would like a macro to autofill down until the next non blank cell is
found and then repeat the autofill with the new cell until the end of
the column ie final result.
Oct05
Oct05
Oct05
Nov05
Nov05
Nov05
Nov05
Dec05

Thanks in advance
Dave