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
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
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!!!
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
ThanksPlease Login or Register to view this content.
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks