Solved

Need a macro that will clear contents in all tabs of workbook

Posted on 2007-11-29
3
206 Views
Last Modified: 2013-11-25
I have a workbook that has over 200 tabs.  I need an easy way to delete everything in the tabs.
0
Comment
Question by:gordon12393
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 59

Accepted Solution

by:
Saurabh Singh Teotia earned 500 total points
ID: 20377834
Well the easiest way that i can tell u is without a macro..and its gonna take one minute only...

Go to any sheet and select that...then where u right name..go there select that...and then right click of mouse and select all sheets...this will automatically select all sheets...

After that u can do Ctrl+a and delete...or just mouse complete delete upto u...

Its a peace of a cake..
0
 
LVL 59

Expert Comment

by:Saurabh Singh Teotia
ID: 20377852
Nd if u want u can record a macro of it while doing it..so next times macro does it for u..and u will automatically will have all the sheet names...
0
 

Author Closing Comment

by:gordon12393
ID: 31411815
Thank you, this worked. I was making it harder than it was :)
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question