Fill specific blanks cells with "Value"

[MattWelsh]

Hello, how do I fill blanks with desired value until data ends in next column.

EDIT: I trying to do this with VBA.

 

[Joe4]

I think key details are missing.

You say that you want VBA to do this.
How should it determine which column and the starting row to begin in?
Or is it always a set row and starting column?

And where should it get the value to populate?
Will it always be the same (hard-coded), or would you like the VBA code to prompt the user for it?