ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Setting page length to 60 lines? (How do?) (https://www.excelbanter.com/excel-programming/394303-setting-page-length-60-lines-how-do.html)

Chet

Setting page length to 60 lines? (How do?)
 
Does anyone know a way to set the page length of a document to be 60
lines versus 66 lines as it currently seems to default to using VBA?
I am trying to print documents and each one is 60 lines long but I see
only a few different "paper size" options on Page Setup.

Thanks,
Chet


JLGWhiz

Setting page length to 60 lines? (How do?)
 
I would think that you could adjust the margins with Page Setup to limit the
number of lines. I don't have any specific numbers for you. You would have
to do a little trial and error to get the margin measurements right.

"Chet" wrote:

Does anyone know a way to set the page length of a document to be 60
lines versus 66 lines as it currently seems to default to using VBA?
I am trying to print documents and each one is 60 lines long but I see
only a few different "paper size" options on Page Setup.

Thanks,
Chet



JLGWhiz

Setting page length to 60 lines? (How do?)
 
I should also mention that font size plays a part in setting the margins. If
the font changes, it will probably impact the margin setting. Einstein's
theory applies.

"Chet" wrote:

Does anyone know a way to set the page length of a document to be 60
lines versus 66 lines as it currently seems to default to using VBA?
I am trying to print documents and each one is 60 lines long but I see
only a few different "paper size" options on Page Setup.

Thanks,
Chet



Chet

Setting page length to 60 lines? (How do?)
 
On Jul 27, 12:50 pm, JLGWhiz
wrote:
I would think that you could adjust the margins with Page Setup to limit the
number of lines. I don't have any specific numbers for you. You would have
to do a little trial and error to get the margin measurements right.



"Chet" wrote:
Does anyone know a way to set the page length of a document to be 60
lines versus 66 lines as it currently seems to default to using VBA?
I am trying to print documents and each one is 60 lines long but I see
only a few different "paper size" options on Page Setup.


Thanks,
Chet- Hide quoted text -


- Show quoted text -


I think the problem is that the printer still thinks that the paper is
11 inches tall when it's really 10 inches tall. The margins only
creates a buffer inside that assumed 11 inch tall piece of paper. I
actually need to tell the printer to advance a total of 10 inches from
top-of-form to the next top-of-form. (I think that's the case.) Chet


Chet

Setting page length to 60 lines? (How do?)
 
On Jul 27, 12:54 pm, JLGWhiz
wrote:
I should also mention that font size plays a part in setting the margins. If
the font changes, it will probably impact the margin setting. Einstein's
theory applies.



"Chet" wrote:
Does anyone know a way to set the page length of a document to be 60
lines versus 66 lines as it currently seems to default to using VBA?
I am trying to print documents and each one is 60 lines long but I see
only a few different "paper size" options on Page Setup.


Thanks,
Chet- Hide quoted text -


- Show quoted text -


Haa.. which Einstein's theory is that.... ?? :)



All times are GMT +1. The time now is 12:43 PM.

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