Insert Formulas and Formats

[Shawn]

Here is my code:

Selection.EntireRow.Select
Selection.Copy
Selection.Insert Shift:=xlDown

I am wanting it to copy a row and insert the copied row pusing the other
rows down. I want the new row to have all the formats and formulas of the
copied row. ???

 

[Shawn]

My code inserts the new row where I want. The copied row has several cells
with formulas in it. When the pasted row is created, it doesn't have the
formulas in it. I am needing like a paste all or something?

 

[OssieMac]

If the formulas only refer to cells to the right or left of them then they
will copy. Otherwise they do not work. Can even cause circular references.