VBA Copy Formula Down Without Formatting

[LauraSophie]

Hi,
I have a macro that copies a formula down to the end of the data (with a variable amount of rows) however I was hoping to add something or amend it so that when it copies down it fills without formatting.
What I have at the moment is:

 Range("C2").AutoFillDestination:=Range("C2:C" & Cells(Rows.Count,"A").End(xlUp).Row)

Any help would be greatly appreciated.
Thanks

 

[Fluff]

Try

Range("C2:C" & Cells(Rows.Count, "A").End(xlUp).row).Formula = Range("C2").Formula

 

[JackDanIce]

Try:

Dim x As Long
x = Cells(Rows.Count, 1).End(xlUp).Row
With Cells(2, 3)
    .Copy
    .Resize(x - 1).PasteSpecial xlPasteFormulas
End With
Application.CutCopyMode = False