VBA to fix auto-fit cell heights not printing properly.

[mnadamn19]

Auto fit row height with wrapped text is cutting of lines when printed but shows fine in the display

• This is due to excel not being setup perfectly for printing and what you see is not always what you get.
• I can get it to work by changing the print resolution, but this setting does not work on all printers. This workbook will be used by 20 people with many printers and I would like to have a vba solution that would not require the user to adjust settings to print.
• Currently the cell heights are auto-fit as cells will have (but not limited to) 1-10 lines of text.
• The VBA code that I have is designed to make a report and print it, I have

Thanks in advance for any and all help!

Please Login or Register  to view this content.

[xladept]

I assume you've formatted wrap text?

[mnadamn19]

yes, it is formatted as wrapped text. I know that the issue is with printing through excel due to http://excel.tips.net/T002785_Printo...ome_Cells.html. I was just hoping that there was a way that I could do it as a before print or something like that. I may just have to have the user select their printer and go through a print preview first to make sure that their resolution works with the printout though this is not my preferred method.

[xladept]

Maybe:

Please Login or Register  to view this content.

[mnadamn19]

Thanks! I changed the +5 to 7 and ended up working on all resolutions!

[xladept]

Excellent! You're welcome and thanks for the rep!