I have a workbook that contains over 100 sheets, all built from templates. Some of them contain data and some do not. i'd like to delete all of the ones that do not contain data. I found and modified this code from another post.
This code does not work but it at least shows what i'm trying to do.
Please Login or Register to view this content.
Last edited by sjennings007; 02-26-2014 at 12:45 PM.
what part does not work?
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
When I run the code, it deletes all spreadsheet where this is true and then stops the first time it is false. If i click on the next spreadsheet where this is true, it then deletes the prior spreadsheet (where its false), and then continues deleting true worksheets until it hits the next false one.
shg,
I'm not familiar with what your if statement is saying.
PS. nothing happens when i try that. Note that all of the worksheets have stuff in them (since they were created with a template) but only some have user entered data.
It counts cells containing anything; if there are none, it deletes the sheet.
In your code,
Range refers to the active worksheet, not the worksheet of the loop variable, which would bePlease Login or Register to view this content.
Please Login or Register to view this content.
Ok, cool. thanks shg.
So in this case where every sheet does contain stuff, it won't work?
PS adding ws.range.... worked. problem solved thanks.
Last edited by sjennings007; 02-26-2014 at 12:43 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks