| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set two different &Pages in a Worksheet
Hi all
how to make, in a worksheet, the pages number (&n in pagesetup) "restart" for different ranges Thanks in advanc João |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set two different &Pages in a Worksheet
Hi
one way: record a macro while manually printing the ranges and changing the pagenumbers -- Regards Frank Kabel Frankfurt, Germany João Rodrigues wrote: Hi all, how to make, in a worksheet, the pages number (&n in pagesetup) "restart" for different ranges ? Thanks in advance João |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set two different &Pages in a Worksheet
Thank you for reply
I wasn't clear enough. I'm using VBA. What i'm trying is to set different page numerations in the same worksheet pagesetup. The bottom line is to print to document's with a single PrintOut method João |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set two different &Pages in a Worksheet
Hi
you can't. You first set the first pagenumber, print out the relevante sheets with .printout, then change the pagenumbering and print the remaining sheets. -- Regards Frank Kabel Frankfurt, Germany João Rodrigues wrote: Thank you for reply. I wasn't clear enough. I'm using VBA. What i'm trying is to set different page numerations in the same worksheet pagesetup. The bottom line is to print to document's with a single PrintOut method. João |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set two different &Pages in a Worksheet
João,
e.g. &Page+5 of &Pages+20 NickHK "João Rodrigues" wrote in message ... Hi all, how to make, in a worksheet, the pages number (&n in pagesetup) "restart" for different ranges ? Thanks in advance João |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of pages in worksheet doesn't match Print Preview pages | Excel Discussion (Misc queries) | |||
| Fill across worksheet pages | Excel Worksheet Functions | |||
| how do you print 2 pages per worksheet | Excel Discussion (Misc queries) | |||
| How do I delete pages in a worksheet? | Excel Worksheet Functions | |||
| Blank Worksheet Pages | New Users to Excel | |||
Hybrid Mode
