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

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

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

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

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

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