insering a row to spreadsheet using VB

[Alex]

Please advise,
how to insert a row to Excel spreadseet from VB.

Thanks

 

[mudraker]

You will need to know where you wish to insert the rows


insert one row at row 5

Rows(5).Insert


insert multiple rows starting at row 5
Rows("5:8").Insert

 

[Alex]

Thanks a lot.