How to insert rows in all worksheets using VB?

[premMS143]

Hi all,

Using VB,
How to insert the required number of rows in all worksheets/selected sheets present in a workbook at a time.
Say an example,
I'm having an Excel file containing 15 worksheets.
Now I want to insert 5 rows @ the beginning for all sheets.
How to do so..?
Could anyone help me. Pls…….

Thanx & regards,.

[prabirchoudhury]

hey

have a look those tutorial/examples may be helpful .....

Insert New row into Excel Using VB
InsertRowAllShe ets()

[Nulli cedo]

Hi all,

Using VB,
How to insert the required number of rows in all worksheets/selected sheets present in a workbook at a time.
Say an example,
I'm having an Excel file containing 15 worksheets.
Now I want to insert 5 rows @ the beginning for all sheets.
How to do so..?
Could anyone help me. Pls…….

Thanx & regards,.

Hi,

I guess you mean new empty rows or do you mean rows containing data.

[Nulli cedo]

Hi I guess you mean new empty rows not rows containg data?