How to know the correct height of the row
I have the worksheet in which all the margines are set to 0 (i.e. left, top,
bottom,right,header,footer). Then I apply the folloing settings FormatStyleModifyFont select Courier New, Reqular, 10. FilePage SetupPaper size : A4 and Print quality : 600 dpi. Now my worksheet contain 73rows/page. Each row has 13.50 points height. so page height is 73*13.50 = 985.5 points But the standard A4 paper size height is 842 points. So how the excel fits the 73 rows of each height 13.5 points? |
How to know the correct height of the row
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 |
How to know the correct height of the row
In Page Setup on the Page tab you can set to 1 Page wide by 1 page tall or
you can adjust this to 1 page wide to 2 pages high etc. If you set to 1 page wide and leave page high blank then it will be one page wide by how ever many pages high is required. -- Regards, OssieMac "Smitesh Tamboli" wrote: I have the worksheet in which all the margines are set to 0 (i.e. left, top, bottom,right,header,footer). Then I apply the folloing settings FormatStyleModifyFont select Courier New, Reqular, 10. FilePage SetupPaper size : A4 and Print quality : 600 dpi. Now my worksheet contain 73rows/page. Each row has 13.50 points height. so page height is 73*13.50 = 985.5 points But the standard A4 paper size height is 842 points. So how the excel fits the 73 rows of each height 13.5 points? |
How to know the correct height of the row
I can only print 60 rows at 13.5 points on A4, which seems about right
60 x 13.5 = 810 Depending on the printer, even with zero margins, the maximum print height is usually a bit less than full A4. Not sure how you can print 73 rows, what do you return with this (in the Immediate window) ?Range("1:73").Height Is your Zoom set at 100%, fit to page maybe Regards, Peter T "Smitesh Tamboli" wrote in message ... I have the worksheet in which all the margines are set to 0 (i.e. left, top, bottom,right,header,footer). Then I apply the folloing settings FormatStyleModifyFont select Courier New, Reqular, 10. FilePage SetupPaper size : A4 and Print quality : 600 dpi. Now my worksheet contain 73rows/page. Each row has 13.50 points height. so page height is 73*13.50 = 985.5 points But the standard A4 paper size height is 842 points. So how the excel fits the 73 rows of each height 13.5 points? |
All times are GMT +1. The time now is 10:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com