I have a workbook that has almost 600 tabs, but only about 200 have data that I need.
Can anyone help me write a macro that check the value of a certain cell, say W300, and deletes each worsheet where it equals zero?
thanks
I have a workbook that has almost 600 tabs, but only about 200 have data that I need.
Can anyone help me write a macro that check the value of a certain cell, say W300, and deletes each worsheet where it equals zero?
thanks
Hi, just off the top of my head this is what I got:
Not tried the code, perhaps someone else knows a better way?Please Login or Register to view this content.
Last edited by gti_jobert; 03-13-2006 at 12:18 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks