Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 88
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 88
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 88
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting length of data in Excel LaBonita Excel Discussion (Misc queries) 1 May 5th 10 02:12 AM
setting a cell length limit jxbeeman Excel Discussion (Misc queries) 1 November 18th 08 02:03 PM
Setting page length to 60 lines? (How do?) Chet Excel Discussion (Misc queries) 7 July 30th 07 03:16 PM
need to know how to control length and height of lines LPN New Users to Excel 2 August 3rd 06 12:04 AM
Setting page length in Excel 2003 Centurian Excel Worksheet Functions 0 January 5th 06 04:07 AM


All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"