Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Las Vegas, Nevada, USA
    Thanked 0 Times in 0 Posts

    Page Number to Exclude Count for Title page and TOC

    I distribute a large Excel workbook with about 50 worksheets plus one sheet each for the Title and Table of Contents which in total prints on 83 pages. I have set Header/Footer |Custom Footer |Right Section to Page &[Page] of &[Pages] on all sheets except the Title and TOC. The first sheet I want pagination to appear on is set to One for Page Setup First |Page Number and Auto for all the rest. As a result of these settings, the last printed and numbered page is 81 of 83 (should be 81 of 81).

    I tried "Page &[Page] of &[Pages]-2" (without the quotes) in a test file but that seems to just tack on the 2 two whatever page number has been calculated.

    What is the solution that does not require manually editing the Header/Footer settings for each of the 50 or so worksheets each time I add or delete a worksheet?
    Last edited by Arcturus16a; 2012-07-18 at 11:44.

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Redcliff, Alberta, Canada
    Thanked 5 Times in 5 Posts
    In cases like this, I've always manually added the total number of pages. I'll be interested if there is a non-vba solution.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts