Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

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

I have a workbook that has over 200 tabs.  I need an easy way to delete everything in the tabs.
0
gordon12393
Asked:
gordon12393
  • 2
1 Solution
 
Saurabh Singh TeotiaCommented:
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
 
Saurabh Singh TeotiaCommented:
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
 
gordon12393Author Commented:
Thank you, this worked. I was making it harder than it was :)
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now