View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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?