How to fill up blank cells by copying from cell above

Dear Sir/ Madam

I need some assistance in VBA. I am new to VBA and programming and I'm trying to auto fill blank cell/s from cell above the empty cell. However, I am not able to get the instruction correct. can you please help me.
Basically I have a work book that consist of data but some cells are empty.

To flash fill formulas and other things you just click on the cell with data on it, then hover your cursor over the bottom right of the cell until it turns into a black plus sign, then drag down to the cells below it

Dear Dohvakin,

thank you for your response.

I am trying to automat a file by running a series of macro programs and for that purpose i want marco to fill the blanks to proceed with the next step in the macro. I hope that make sense sorry i am new to all this! would there by other way than the one you suggested for marco ? thank you

One way

Please Login or Register  to view this content.

or with a loop (= slower)

Please Login or Register  to view this content.