| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Start a page number from 9
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! -- Chanty |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Start a page number from 9
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Chanty" wrote in message ... 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! -- Chanty |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Start a page number from 9
FilePage setupPage tabFirst page number: enter 9
Regards, Stefi €˛Chanty€¯ ezt Ć*rta: 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! -- Chanty |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Start a page number from 9
I cant believe it was so easy! Thank you very much.
-- Chanty "Stefi" wrote: FilePage setupPage tabFirst page number: enter 9 Regards, Stefi €˛Chanty€¯ ezt Ć*rta: 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! -- Chanty |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Start a page number from 9
You are welcome! Thanks for the feedback!
Stefi €˛Chanty€¯ ezt Ć*rta: I cant believe it was so easy! Thank you very much. -- Chanty "Stefi" wrote: FilePage setupPage tabFirst page number: enter 9 Regards, Stefi €˛Chanty€¯ ezt Ć*rta: 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! -- Chanty |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
| start page numbering from page 2 in excel | Excel Discussion (Misc queries) | |||
| Footer set up start Page 2 | Setting up and Configuration of Excel | |||
| how do i start spreadsheet with page 5 | Excel Discussion (Misc queries) | |||
| Start page number on second page | Excel Discussion (Misc queries) | |||
Linear Mode
