|
Posted to microsoft.public.excel.misc
|
|
|
Different Page Numbers In Worksheet w/Page Breaks
Worked perfectly. Thanks a lot!!
"Gord Dibben" wrote:
Set job one print range to first three pages.........say A1:M156
After printing job one you must reset the print range to job two
range...........say A157:M312
You will get page 1 to 3 for job two
Reset print range for job three and get 1 to 3 for job three.
Header can also be changed for each job.
You could also copy pages 1 to 3 to a separate sheet and print from there.
Copy pages 4 to 6 to a separate sheet etc.
Gord
On Thu, 15 Jan 2009 06:19:01 -0800, UT wrote:
The solution worked partly. I could change title in the header but I could
not insert page numbers for the print jobs after the first one. In the footer
when I add "&Page" it displays the actual page number and not the new page
number that I want.
From page 4 to 6, i want to restart the numbering - pg 1, 2, 3
From page 7 to 9, the same thing - pg 1, 2,3
Thanks!
"Gord Dibben" wrote:
I can only suggest after printing job one, re-header and print job two.
Gord
On Wed, 14 Jan 2009 06:58:05 -0800, UT wrote:
That'll work but it looks like different headers & footers cannot be inserted
on one worksheet itself for different page breaks.
Thanks!
"Gord Dibben" wrote:
Still two separate print jobs.
Set up Footer of Page 1 of ? for 3 pages printrange
Set up Header for 3 pages printrange.
Set your PDF application as your Printer and go.
Next print job do same.
Gord
On Tue, 13 Jan 2009 09:52:11 -0800, UT wrote:
I will convert these pages into pdf files. Page 1, Page 2 and Page 3 will be
one pdf file. So I would like the page numbers to be displayed in the pdf
file and not just the printed copy.
Thanks.
"Gord Dibben" wrote:
Multiple print jobs will handle both those problems.
You could use VBA but you would still wind up with separate print jobs.
Ron de Bruin's code would be a start.
http://www.rondebruin.nl/print.htm#not
Gord Dibben MS Excel MVP
On Tue, 13 Jan 2009 07:57:01 -0800, UT wrote:
Hi,
I have one worksheet with vertical and horizontal page breaks. I am trying
to insert different page numbers in the worksheet.
For example Page 1 to Page 3 should have page number 1, 2, 3.
Page 4 to Page 6 should again new page numbers - 1,2,3 and so on
How can do this?
Second issue is that I would like to have a different header for these pages
in the worksheet.
Help appreciated.
ut
|