Hi
I'm trying to use a vba to insert a row, and copy dynamic formulas from above.
I have problem with formulas like "=SUM($F$9:F12)". The new row get the same formula, but should get "=SUM($F$9:F13)".
My vba code is like this:
' Q4 is input to define which row to insert new.
Dim verdi As Variant
verdi = Range("Q4").Value
Rows(verdi).Select
' Copy formula from cell above
Rows(Selection.Row - 1).Copy
Rows(Selection.Row).Insert Shift:=xlDown
End Sub