Print to PDF Macro creating unwanted outcome

**1FrustratedCoder** · 05-25-2023, 12:02 PM

Hello,

Please have patience with me, I have just begun learning how to use VBA literally yesterday. I created a simple macro to print an excel workbook as a PDF and it works perfectly.
The issue I'm running into is that certain worksheets that I'm getting to work on have the print area set well beyond where the table is that actually has data in it.
So because I have my macro set to print with all columns fitting on one page it's shrinking the view of the spreadsheet to an unreadable size.
Essentially fitting 200+ rows of data into the upper left corner of an 8.5x11 in page. Below is a screenshot of the print preview page.

screenshot.jpg

Of course i know how to manually select my print area in the page layout tab, but I'm trying to find a faster way to accomplish this task because my job has a
big focus on speed and having to fix the spreadsheet to make my macro work is ending up taking the same amount of time as it was before I created the macro in the first place.

Please Login or Register  to view this content.

**6StringJazzer** · 05-25-2023, 12:38 PM

Welcome to the Forum 1FrustratedCoder!

You probably have many rows and columns that are considered part of the sheet but have no data. Select A1. Click CTRL+END. What cell do you end up in? If it's way down on row 200, then delete the unused rows and columns (don't just hit DEL to delete data, actually delete the rows and columns). Then save and close the file, open it, and try again.

If none of that works attach your file for us to review.