[Excel] Need to print pages only with text

I have a problem that is frustrating me, because I don't think it is as hard as I'm making it out to be.

I have a spreadsheet with a set print area of 17 pages. However, there won't always be 17 pages worth of information. There may only be, say, 7 pages to print this quarter, or 10 next quarter. Is there a way I can set up a macro to print only the pages with text?

Also, I need to do this over multiple worksheets.

Any insight is much appreciated! Thank you!

Is there a reason you have the print area set? I would think you would use this if you DID want to print the whole area. Without knowing how your spreadsheets are set up, its difficult to answer this.

you could try like
Sheets("sheet1").UsedRange.PrintOut

Instead of using Sheets("sheet1").UsedRange.PrintOut, just remove PrintArea (leave it blank).