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!