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.
gordon12393Asked:
Who is Participating?
 
Saurabh Singh TeotiaConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.