Auto-size column error

[rockchalk33]

Hey all,

So the title of my post is slightly misleading...Some time ago I created two unique programs both serving the same purpose, to take data, organize it, then reproduce it on a PDF format.

This has been working without any type of hiccup until this last week when both programs (that's the super weird and confusing part) will generate PDF documents but neither of which the auto-size column code is working because both ultimately have "#####" somewhere on the document.

If anyone can give me any idea or throw out a thought as to why this would occur after working for many months and then randomly do this on two separate machines?

The code for both programs is very expansive and long. As a troubleshoot, I've gone in and tried to autofit each individual column at the end of my code (didn't work) and then have rearranged the order of auto-fitting different columns (still didn't work) to see if that would fix the issue but there is still no change.

Thanks,

Devin

 

[Jeffrey Mahoney]

Sometimes different printers and different form creation tools such as PDF creators deal with fonts a little differently. See if this helps. You want to auto size the column and then make it a little bit bigger to allow for minor font differences.

Columns("D:D").EntireColumn.AutoFit
Columns("D:D").ColumnWidth = Columns("D:D").ColumnWidth + 0.1