Hello all,

I am using a macro-enabled Office-365 Excel workbook.

I am having trouble with row heights when I export a worksheet to PDF. The number of characters which fit into the merged columns, in the PDF, is greater than in the source worksheet. So, wrapped cell contents in Excel which go over on to a second line, can sometimes fit into a single line in the exported PDF. Therefore the rows, in the PDF, are sometimes taller than they need to be as they are not auto-height but set to a specific height. The autoheight can't be used as the cell contents are generated dynamically and the cell heights calculated and set by VBA.

I am using this to export the worksheet:
Please Login or Register  to view this content.
If I set the Quality to xlQualityStandard, it is worse, and the issue shows in cells which aren't generated dynamically but where the cell contents just happen to slightly over into the second line.

Has anyone come across this before?

When I print the worksheet to PDF rather than Export the problem isn't there, it reflects what is in Excel exactly. However, I don't know what all of the end users will have installed on their machines so can't do print using a PDF drive like cutePDF. It needs to be something contained just within Excel.

Thanks!