VBA Copy and paste rows but keep formulas in place

[Evie76]

Hi,
Below i have a code that copies and pastes rows, which works great. However, it wipes the formulas that are in columns A,C,D, F,H,I. Is anyone able to advise on how i can edit the code to keep the formulas in place

Application.ScreenUpdating = False

Range("A48:M63").Copy

Sheets("Completed_SVTs").Range("C" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False



    Range("A48:M63").Select
    Application.CutCopyMode = False
    Selection.ClearContents
    Range("A1").Select

Application.ScreenUpdating = True

Kind regards

Eve

 

[Legacy 143009]

xlPasteValues

Try change this parameter to this:
xlPasteFormulas

 

[Darmlucht]

I had a similar issue where if a formula resulted in for example a word (for example an If statement that is true, then it would put GO in the cell)
and I would copy and paste that row to another, it would just print GO in that cell, without reference to a formula or something.
I am looking for this as well, so I can copy and paste formulas easily from one row to another.