Insert Row & Paste Data

G

Guest

I'm hoping someone can help me.
I'd like to know what code I need to insert a row below the current line I'm
working in, then to copy all formulae and formats from A50:AM50 (named range
"property") and paste this into the same columns in the row that has been
inserted.
 
G

Guest

something like this

ActiveCell.Offset(1, 0).EntireRow.Insert
Range("property").Copy ActiveSheet.Range("A" & ActiveCell.Row + 1)
 

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
Changes in How Code Acts After Upgrade of Excel 2
Import multiple workbooks to current workbook in specified row number 0
Retrieving Current Row,Columns & copying Format from Row,Columns a 2
Paste in column B using Last row of either column B, C or D. 10
Copy non blank rows only 2
Run-time error when copying entire row! 5
Insert Row & Copy Formula 2

Top