Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... ?? :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting length of data in Excel | Excel Discussion (Misc queries) | |||
setting a cell length limit | Excel Discussion (Misc queries) | |||
Setting page length to 60 lines? (How do?) | Excel Discussion (Misc queries) | |||
need to know how to control length and height of lines | New Users to Excel | |||
Setting page length in Excel 2003 | Excel Worksheet Functions |