Printing the correct number of pages.

Discussion in 'Microsoft Excel Worksheet Functions' started by Colin Hayes, Sep 8, 2004.

  1. Colin Hayes

    Colin Hayes Guest

    Hi all

    I have a small puzzle which I hope you can help with.

    I want to place a control button on a page to print as many pages as the
    varying amount of rows requires. It's set up as A4 portrait. Sometimes ,
    there are only a few lines of entry on a page , sometimes there are
    dozens of lines. I need a small routine to place under my button to
    print just the right amount of pages that the varying amount of rows
    demands - is this possible?


    Thanks

    Drno
     
    Colin Hayes, Sep 8, 2004
    #1
    1. Advertisements

  2. Colin Hayes

    Colin Hayes Guest

    In article <RnN$>, Colin Hayes
    <> writes
    >Hi all
    >
    >I have a small puzzle which I hope you can help with.
    >
    >I want to place a control button on a page to print as many pages as the
    >varying amount of rows requires. It's set up as A4 portrait. Sometimes ,
    >there are only a few lines of entry on a page , sometimes there are
    >dozens of lines. I need a small routine to place under my button to
    >print just the right amount of pages that the varying amount of rows
    >demands - is this possible?
    >
    >
    >Thanks
    >
    >Drno



    Hi

    Clearly no one knows the answer to this one.

    Thanks for looking anyway.

    drno
     
    Colin Hayes, Sep 10, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Calculating dates to get correct number of years

    Guest, Oct 14, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    135
    Frank Kabel
    Oct 14, 2004
  2. Guest

    How do i format a 5 to 6 digit number into the correct date?

    Guest, Jun 10, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    148
    Guest
    Jun 10, 2005
  3. pajones via OfficeKB.com

    Selecting the correct number from a range of cells

    pajones via OfficeKB.com, Sep 18, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    8
    Views:
    147
    pajones via OfficeKB.com
    Sep 18, 2006
  4. pajones via OfficeKB.com

    Selecting the correct number from a range of cells

    pajones via OfficeKB.com, Sep 18, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    137
    pajones via OfficeKB.com
    Sep 18, 2006
  5. santosh kutre

    how to correct the decimal number to the nearest even number

    santosh kutre, Nov 3, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    171
    Bob Phillips
    Nov 3, 2008
Loading...

Share This Page