How to insert rows in all Worksheets present in a single workbook

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • premMS143
    New Member
    • Nov 2008
    • 75

    How to insert rows in all Worksheets present in a single workbook

    I've created a application using VB.
    Here, how to code to insert number of rows (user mentioned) in an existing excel worksheet ....?

    In this, User has prompted,
    1. Select an existing excel file in which rows to be inserted..
    2. how many rows to be inserted & from which row number..?
    3. Whether to insert for only one sheet or all sheets present in Workbook...?

    A single command button has supposed to do this.
    Clicking on cmd button, it has to insert 5 rows for example in a selected excel work book for all sheets.


    Could anybody help me please....


    Thanx
    TeamWork
Working...