insering a row to spreadsheet using VB
 

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

Thanks

insering a row to spreadsheet using VB
 

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


---
Message posted from http://www.ExcelForum.com/

insering a row to spreadsheet using VB
 

Thanks a lot.


-----Original Message-----
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


---
Message posted from http://www.ExcelForum.com/

.