ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printer Settings (https://www.excelbanter.com/excel-programming/292846-printer-settings.html)

MERLYN KNIGHT

Printer Settings
 
I am using VBA to create a page with cells with medium borders. When it
prints on a Laser printer set to 600 dpi it prints on one page. When the
printer is set to draft the columns are wider and the rows are taller even
though row height is 16 in both cases and column width is 15 in both cases
and it prints the last row on the next page.
I have checked the style settings and the font for "Normal" is 8. It is as
thought the column width is is changed to a style with font size 10 rather
than 8.




All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com