the way you are writing the code it will only work with certain
printers and not with other printers. Normally I don't worry about the
dpi settings. Instead I choose a font size and then add page breaks
after a fix number of rows. When I reformat a page I remove all the old
page breaks and read add new ones. Let the print driver determine the
margin sizes or set the martgins and make sure the number of rows per
page is less than the paper size minus the size of the margins.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=186584

Excel Live Chat