Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: I want 1st page of my printout to have pg 3 not 1 and incr from there

    I want to have custom footer and header where i can increment the page # so if the page # is 1 and i want it to be 6 (other pages from pdf are pages 1-5 how can i do this? i tried

    ActiveSheet.PageSetup.CenterFooter = (IIf(blnBoard, "&B&14&P" & "+" & mynum, ""))

    but i get 15 when i look at the page setup dialog i see:

    how can i do this??

  2. #2
    Join Date
    Apr 2009
    On Page Setup, on the Page tab at the bottom is a box labelled "First Page Number" which defaults to Auto. If you always want it to start at 6 for this workbook (possibly worksheet, not sure), just change here and save the workbook.

    If you want to be able to change the starting number in code then you need:
    ActiveSheet.PageSetup.FirstPageNumber = [whatever you want it to equal]

Posting Permissions

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