Macro VBA Code to Insert New Row and Copy Formula and Value from above row

[manish2387]

Hello Gurus, I need your help.

I want to write a simple macro code which will do following

1) It will insert an empty row below the active row
2) It will copy selected formula and/or value from above row for specified columns.

Can you help me send macro code for this case?

Thanks you
Manish

 

[JoeMo]

Sub InsertAndCopy()
With Selection
       .Offset(1, 0).Insert shift:=xlDown
       .Resize(2, .Columns.Count).FillDown
End With
End Sub

 

[aljazd]

Hey everyone,
how would the code look if I only wanted to copy the formula but not the value?
Thank you for your reply in advance!