Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

deleting sheets

ResolvedVersion 2003

John has attended:
No courses

Deleting sheets

How do you delete sheets already present in VBA and then re create.

RE: Deleting sheets

Thank you for your question.

To delete a sheet using VBA use

Sheets("MyData").Delete


To add a sheet using VBA use

Worksheets.Add



Regards
Laura GB

Tue 27 Jan 2009: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Currency format

Ctrl+Shift+$ applies the Currency format, with two decimal places

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.18 secs.