AllExperts > VB Script 
Search      
VB Script
Volunteer
Answers to thousands of questions
 Home · More VB Script Questions · Answer Library  · Encyclopedia ·
More VB Script Answers
Question Library

Ask a question about VB Script
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Subbu
Expertise
I can answer VB Script questions which are related to Visual Basic / VBA / QTP Scripts.

Experience
8 Years

Education/Credentials
Master of Computer Applications

Awards and Honors
Established Member from QA Forums and Brainbench certification

 
   

You are here:  Experts > Computing/Technology > Basic > VB Script > VB script for excel

VB Script - VB script for excel


Expert: Subbu - 5/20/2009

Question
How to change the name of the existing worksheet in excel

Eg: sheet1 to data1

how to insert a new row in the existing excel sheet.
and how to delete an empty row in the excel sheet

Answer
Sreedhar

How to change the name of the existing worksheet in excel:

Double click on sheet1 and press Del button and type what ever you want as sheet name

how to insert a new row in the existing excel sheet:
select the Row number where you want insert a new row and click right mouse button and select Insert Option.


and how to delete an empty row in the excel sheet:

Same as insert row, it means select that row which you want to be deleted and click right mouse button and select Delete option.

You can also do them using Macro code if you have a ton of them.

Subbu.

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.