Page numbering question
 

I have about 40 pages in a sheet. I want to number the pages. But I want
the first two pages to have no numbers. I want the number to start as 1
on the third page. I know this sounds simple. But I cannot figure out a
way to do it. Can anyone help?


--
waiteja
------------------------------------------------------------------------
waiteja's Profile: http://www.excelforum.com/member.php...o&userid=31108
View this thread: http://www.excelforum.com/showthread...hreadid=507856

Page numbering question
 

I don't have a great solution, but a workaround.

You need to make a duplicate copy of your worksheet. On the first one,
remove the page numbering, and set the print area so that only the first two
pages print, and there are no page numbers in the footer. Set the second
worksheet to print the remainder of the document, with page numbers.



"waiteja" wrote:


I have about 40 pages in a sheet. I want to number the pages. But I want
the first two pages to have no numbers. I want the number to start as 1
on the third page. I know this sounds simple. But I cannot figure out a
way to do it. Can anyone help?


--
waiteja
------------------------------------------------------------------------
waiteja's Profile: http://www.excelforum.com/member.php...o&userid=31108
View this thread: http://www.excelforum.com/showthread...hreadid=507856

Page numbering question
 

Hi waiteja

You can use a macro to do this

Sub Test()
Dim TotPages As Long
TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
With ActiveSheet.PageSetup
.LeftFooter = ""
ActiveSheet.PrintOut From:=1, To:=2
.LeftFooter = "&P-2 "
ActiveSheet.PrintOut From:=3, To:=TotPages
End With
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl


"waiteja" wrote in message
...

I have about 40 pages in a sheet. I want to number the pages. But I want
the first two pages to have no numbers. I want the number to start as 1
on the third page. I know this sounds simple. But I cannot figure out a
way to do it. Can anyone help?


--
waiteja
------------------------------------------------------------------------
waiteja's Profile: http://www.excelforum.com/member.php...o&userid=31108
View this thread: http://www.excelforum.com/showthread...hreadid=507856