How to set two different &Pages in a Worksheet

J

João Rodrigues

Hi all

how to make, in a worksheet, the pages number (&n in pagesetup) "restart" for different ranges

Thanks in advanc
João
 
F

Frank Kabel

Hi
one way:
record a macro while manually printing the ranges and changing the
pagenumbers
 
J

João Rodrigues

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
 
F

Frank Kabel

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