Page numbering question

W

waiteja

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

Jonathan Cooper

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.
 
R

Ron de Bruin

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
 
Top