Basically when I use this code to print it works great if there is a sheet to print, if there isn't a sheet to print I get a run time error, which isn't necessarily a big deal but for esthetic reasons I would like to have a dialog box come up that says "Sorry, nothing to print" if there is nothing to print.
Please Login or Register to view this content.
When won't there be a sheet to print?
If posting code please use code tags, see here.
Right above the print command put
then at the bottom above end sub putPlease Login or Register to view this content.
Please Login or Register to view this content.
There can be up to 50 different (types of) pages in the workbook to print, dont want to check through entire workbook to see what there is to print, so have a pag with buttons that can print each type of page from one tab.Originally Posted by Norie
So there's no criteria/logic that can be used in the code to determine whether or not there are sheets to print.
PS The code you posted loops through all the worksheets already.
The criteria for this particular sheet is that if there is a value in cell A607 then it will print, if there is no value in A607 then it will not print.
Sorry you've lost me there.
You are using the same criteria for all sheets and putting the name of each sheet that has A607 populated in an array.
I think that checking what N is might be an idea.
If it's 0 then no sheets have A607 populated.
In fact I'd change the loop to this.
If N is 0 then the code within the loop will never execute as you can go from 1 to 0.Please Login or Register to view this content.
Last edited by Norie; 07-08-2013 at 04:50 PM.
Thanks Norie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks