Excel 2003 - VBA - Insert Row

  • Thread starter Thread starter Craig Brandt
  • Start date Start date
C

Craig Brandt

Hi guys,

What I would like to do is insert a row in a table, then copy the previously
selected row and paste those formulas in the added row.
I have figured out how to find the entry point. From there I can add a blank
row.
My problem is how do I reselect the row with the data then select the blank
row to paste in the data.
This seems like it aught to be easy, but for the life of me, I cannot figure
it out.

Thanks for any help,
Craig
 
Hi guys,

What I would like to do is insert a row in a table, then copy the previously
selected row and paste those formulas in the added row.
I have figured out how to find the entry point. From there I can add a blank
row.
My problem is how do I reselect the row with the data then select the blank
row to paste in the data.
This seems like it aught to be easy, but for the life of me, I cannot figure
it out.
Click to expand...
I have something like:
Worksheets("SoldShares").Rows("3:3").Copy
Worksheets("SoldShares").Rows("3:3").Insert Shift:=xlDown
Application.CutCopyMode = False

Arrange so you can view the sheet and the code at the same time and step through
it, you will see how it works. You will need to change the sheet names and row
numbers to suit you situation of course.
 
Back
Top