Inserting Rows in Excel using VBA

[Arbeeone]

Hi,
I'm manipulating a large file and want to insert rows programatically within VBA so that I can include sub-totals and also some other formatting to make the output look better. I'm using the Range(Cells(1,1),Cells(r,1)).Select method elsewhere (where 'r' is the row number), but this doesn't work when I come to defining a row where I want to insert additional rows.

Any help on how I can insert at rows at variable points from within VBA would be greatly appreciated!

rsb

 

[OBP]

One way to learn is to record a macro of you inserting rows.

 

[Rollin_Again]

If r is the variable row number, you can insert rows by using

Rows(r).Insert

Rollin