Thread: Print Specific Charts

Hello Excel Experts,

I have a little problem with some code I've been using. In my workbook I have 7 sheets with 45+ pre-made charts. Some have data but most don't. The current code I have counts how many charts there are on the sheet, selects, activates, and prints them all the way I like. Thing is I'd like it to print only the charts with data in them.

I thought that a code could be made that checks the source range of the chart for numbers then prints that chart. However because there are 45+ charts and 7 sheets that would take awhile

I'm hoping someone here will be able to help me out. Attached is a example I put together with the code i'm currently using.