VBA Code to Auto Adjust Page Breaks

[Justinian]

Every day, I export data from an external database and paste into Excel. From there, I run a macro cleaning up formatting and removing bad data but the number of pages varies day to day and the page break always causes a few blank pages to print. How do I input code into my extant macro so only pages with data print?

 

[Justinian]

There are no objects and yes, blank pages are still being printed. Right now, Page #9 through #16 are blank.

 

[pbornemeier]

If you manually delete all columns to the right of the last visibly filled column and rows below the last filled row does Print Preview or Print still show extra pages?.

 

[Justinian]

Yes.

 

[pbornemeier]

Can you manipulate the page breaks in View | Page Break Preview to eliminate the extra pages?

 

[Justinian]

Of course but this macro is run by my coworker who is not very computer savvy and she always prints the extra pages.