I have another vba question: In column A there are rows that are
populated and rows that are not.

I want the empty cells to look up and copy the first non empty cell
value to the specific cell.

A1: Test
A2:
A3
A4
A5 Bla Bla
A6
A7

The code should give: A2, A3 and A4 to be "Test" as well and A6 and A7
to be "BLa Bla"