Macro to Fill Blank Cells

Hello, Can anybody help me?

I need a macro that will select blank cells in a column and fill in the blank cells with the values immediately above the blank cells.

Example

ROWS
A

1234



5678



9876
4256

This means that I need the macro to fill in the Blank cells between (1234)&(5678) with 1234. Then fill in the Blank cells between (5678)&(9876) with 5678.

Any help is greatfully appreciated.

Thanks

Do you really need code?

1. Select the column with the blanks.
2. Goto Edit>Goto...Special and select blanks.
3. Goto the formula bar, enter =A1 (or whatever the first cell with data is) and then press CTRL+ENTER.
4. Select the column, copy and paste special values.

Hi VBA Noob I think I posted a reply to your response. YES the code you gave me worked out perfectly!!!

Thanks Again.

Norrie I tried what you told me and yes it worked out as well.

Thanks a bunch both of you guys.

Thanks