Macro to auto-fill all the blank cells ???

Hi guys -

I have an Excel macro problem.

I have a spreadsheet with a column that's formatted like this:

blank
6575
blank
blank
blank
4457
blank
blank
blank
blank
3355

Obviously the 'blanks' are blank cells and there are about 10,000 rows in the sheet.

I would like to autofill the blank cells so that the value BELOW them is repeated, so it would actually look like this:

6575
6575
4457
4457
4457
4457
3355
3355
3355
3355
3355

Any ideas?