+ Reply to Thread
Results 1 to 4 of 4

Header Page Number not starting at 1

  1. #1
    Forum Contributor
    Join Date
    06-12-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    167

    Header Page Number not starting at 1

    Hello,

    I am trying to change my header to have a page number however it needs to start at page 2 as another document will be attached before it labeled as page 1. Is this possible?

    Thanks

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,162

    Re: Header Page Number not starting at 1

    Excel?....Sure anything is possible...However, have no idea what you mean...Upload a sample file depicting BEFORE/AFTER scenario
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    06-12-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    167

    Re: Header Page Number not starting at 1

    Not exactly sure how to make the sample do what I want by hand either. Basically I just want to do like you double click in the header section then go to the design tab and click page number. It then adds &[Page] which I can get not problem. What I need is for on what is page 1 of the sheet for this &[Page] to read as 2 then the next page 3 and so on.

    Essentially &[Page] +1 (I tried to put it in my code with a +1 and it didn't work)

    When I record a macro in Microsoft Word where I know how to do this the code looks like this
    Please Login or Register  to view this content.
    Thanks

  4. #4
    Forum Contributor
    Join Date
    06-12-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    167

    Re: Header Page Number not starting at 1

    I figured out that it is the &P+1 however this only works for me when I step through the code. If I just run the whole thing it completely messes up the heading. I have stepped through all of the lines and had nothing go wrong and then as soon as I hit run to let it step through itself it did it incorrectly.

    Have you ever had this happen?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Page Number in Header
    By dougman824 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2017, 05:23 PM
  2. Macro to Create a Page Break Every X Number of Pages Starting in the Print Area
    By Lyndy Januszewski in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-13-2017, 01:41 PM
  3. Repeating the header at the start of each page with the page number
    By Viswateja in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2017, 02:17 PM
  4. [SOLVED] Worksheet with Page numbers starting from a set number
    By Deventus in forum Excel General
    Replies: 4
    Last Post: 09-03-2014, 07:23 PM
  5. [SOLVED] Change Header/Footer Page number
    By bsamuels in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2013, 04:10 AM
  6. Changing Header Based on Page number
    By SEAEngineer in forum Excel General
    Replies: 2
    Last Post: 08-17-2007, 01:20 PM
  7. page number other than the header footer option
    By vandy in forum Excel General
    Replies: 0
    Last Post: 06-08-2006, 09:20 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1