There are instructions here for filling blank cells manually or
programmatically:

http://www.contextures.com/xlDataEntry02.html

Clive Darling wrote:
Need to fill blank cells in a column with the data from the previous
non-blank cell in Excel 2000. Used to do this in Lotus. Can't seem to get it
in Excel




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html