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?
-
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.
VBA Code to Auto Adjust Page Breaks
Excel Facts
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
pbornemeier
Well-known Member
- Joined
- May 24, 2005
- Messages
- 3,911
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?.
Upvote
0
pbornemeier
Well-known Member
- Joined
- May 24, 2005
- Messages
- 3,911
Can you manipulate the page breaks in View | Page Break Preview to eliminate the extra pages?
Upvote
0
