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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keeping formulas on an insert 1
Copying a row and pasting the same below it with just formulas 3
Changes in How Code Acts After Upgrade of Excel 2
Can Vba workout if a selection is part of a group? 0
Macro: insert rows anywhere in the sheet 4
Inserting new rows into sheet 2
Macros will not work when sheet e-mailed 4
Inserting results below and not above 2

Back
Top