Start a page number from 9

  • Thread starter Thread starter Chanty
  • Start date Start date
C

Chanty

I have an Excel spreadsheet that is going to be slotted into a Word report
once printed. The spreadsheet must have page numbers, but the first printed
page must start at 9, not at 1. Please help!
 
You can do this with VBA. Copy this into a general module

Sub PageNine
Worksheets("Sheet1").PageSetup.FirstPageNumber = 9
End Sub

or open the VBA Editor and copy just
Worksheets("Sheet1").PageSetup.FirstPageNumber = 9
into the Immediate window and press Enter

New to VBA? See:
David McRitchie's site on "getting started" with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Debra Dalgleish's "Adding Code to a Workbook"
http://www.contextures.com:80/xlvba01.html

best wishes
 
File>Page setup>Page tab>First page number: enter 9

Regards,
Stefi

„Chanty†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing spreadsheet with a lot of columns 3
Importing Excel report into Word showing headers and footers 1
change starting page number 2
Sequential Numbers 5
Continuous page numbering when printing whole book 2
Scaling in Excel 1
Page Count with Tabs 3
Auto Page Numbering Question 2

Back
Top