I am creating an Excel spreadsheet where a user can enter in data on a form and once they are done it places that information onto another worksheet which creates a spreadsheet that will print out 32 bin labels. My bin label sheet can print out as much as 7 sheets with different information on it. Is there a way to print only 1 or 2 sheets based on whether there is information in those cells? In otherwords when a user hits the print button I don't want the remaining pages to print if there is no data on those pages.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VB Code to Print certain Cells
- Thread starter berenger
- Start date
