472,133 Members | 1,217 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,133 software developers and data experts.

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
May 5 '09 #1
0 1713

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by e.h.doxtator | last post: by
4 posts views Thread by hangar18 | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.