To copy the same value in the next blank cell below it in a column

[pksreela]

sir/madam


I have a set of value in a column with some cells empty,I just want to paste the same value in the blank cells in the column just below it,As given here,the number 73 should be filled in the blank cells just below 73,next fill 45 in the blank cell below 45 ..... The data I am handling is much more that I have to sit at least one week to fill in all the EMPTY cell with the same value above it .Filling these data is really turning me blind ....I hope friends for a simple formula for this.



regards
sree

73


45


56


32

[tom1977]

Hi use such trick
1. select column with data
2. press F5
3. choose "special"
4. choose "empty cells"
5. type symbol "="
6. Press arrow "up" this under "End" button
7. Press CTRL + ENTER

[tejvilsan]

Hi,
Can u please provide a macro for same?

Thanks.

[tom1977]

try such line

Columns("A:A").SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C"

[tejvilsan]

Hey It worked....
Thanks a lot

[tejvilsan]

Hello,
I tried above code. It workeed. But throws error, if it does not find any blank cells.
Could you please help me for this?

Thanks in advance.