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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
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:
    213
    Frank Kabel
    Oct 14, 2004
  2. Guest

    How do i number pages in a header consequently

    Guest, Jan 22, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    188
    Guest
    Jan 23, 2005
  3. 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:
    181
    Guest
    Jun 10, 2005
  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:
    8
    Views:
    192
    pajones via OfficeKB.com
    Sep 18, 2006
  5. 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:
    158
    pajones via OfficeKB.com
    Sep 18, 2006
  6. GE Cathey
    Replies:
    1
    Views:
    562
    Guest
    May 16, 2007
  7. Guest

    sum product not returning correct number

    Guest, Sep 28, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    166
    Ron Rosenfeld
    Sep 28, 2007
  8. 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:
    244
    Bob Phillips
    Nov 3, 2008
Loading...