How to set two different &Pages in a Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

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

Thanks in advanc
João
 
Hi
one way:
record a macro while manually printing the ranges and changing the
pagenumbers
 
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
 
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.
 
You must log in or register to reply here.

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 issue 1
PageSetup.Zoom=TRUE 3
set PageSetup.PrintArea from MS Project 1
Setting PageSetup Properties in Multiple Worksheets 10
PageSetup changes not working in VBA 1
How to reference a cell from anther workbook without opening it 0
Populating a range of empty cells with usernames 4
how to set the zoom property 3

Back
Top