Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2007-11-29
3
Medium Priority
?
209 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 2000 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

705 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