No, that also assumes no missing data in column A and will only filldown to
the row above the blank cell.
This will filldown to the last used cell in column A, but will also put the
formula opposite a blank cell.

Range("C1", Cells(Rows.Count, "A").End(xlUp)).Offset(0, 2).FillDown

Basically same explanation except now we determine how far up column A do we
want to filldown in column C.

Mike F
wrote in message
oups.com...
Super !!! Just a one liner. Will this solve the above problem? (if
there are empty cells in between A1 and last row in column A)

Mike Fogleman wrote:
Try this:

Range("C1", Range("A1").End(xlDown)).Offset(0, 2).FillDown

Explanation: Range("C1", -is what to filldown
Range("A1").End(xlDown) -is how far to filldown (End of column A)
.Offset(0, 2) -is which column from Range("A1") to filldown (2 columns
to
the right =C)

Mike F