Insert Formulas and Formats

  • Thread starter Thread starter Shawn
  • Start date Start date
S

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. ???
 
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?
 
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.
 
Back
Top