Start a page number from 9

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!
 
B

Bernard Liengme

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
 
S

Stefi

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

Importing Excel report into Word showing headers and footers 1
Remove page titles from only one page 1
How do I get "PAGE 1" removed from an Excel spreadsheet? 2
Have Extra Page - how do I get rid of it? - Excel 2007 2
Excel - not everything is printing out? 1
Auto Page Numbering Question 2
Can I print a single column sheet as multiple columns? 1
Why are large reports truncated in Excel? 1

Top