Excel 2003 - VBA - Insert Row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig Brandt - 29 Apr 2008 14:39 GMT

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

Reply to this Message

Gord Dibben - 29 Apr 2008 15:48 GMT

See David McRitchie's site for a macro to insert a row and copy formulas from
above.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

Gord Dibben MS Excel MVP

>Hi guys,
>
[quoted text clipped - 9 lines]
>Thanks for any help,
>Craig

Reply to this Message

Dave Mills - 29 Apr 2008 23:27 GMT

>Hi guys,
>
[quoted text clipped - 6 lines]
>This seems like it aught to be easy, but for the life of me, I cannot figure
>it out.

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.

>Thanks for any help,
>Craig

Reply to this Message

Rate this thread: