Dear All,

I have a sheet that contains 2 colunms, A and B; they look like below:

A: B:
X 1
Y (empty)
Z (empty)

The last two cells in column B are empty, but this is subjected to change
I would like to paste the value of a cell (eg D3) to fill in the empty cells in column B with VBA (the last n cells are empty, there are no other empty cells)

Could you please help?
Many thanks