What is a simple way (in a macro) to copy a formula down an empty column and
only paste the formula if data exists on that row?

I've used {Worksheets("Sheet1").Range("A1:A100").FillDown} when I know how
many rows have data, but in this case I don't have any idea how many rows
there may be with data.

Thanks for any help.