View Single Post
  #4   Report Post  
RagDyeR
 
Posts: n/a
Default

Are you saying that you want the 3 *Print Pages* of Sheet 1 to display,
"Page 1 of 14"?
AND ... have Sheet 2 display "Page 2 of 14"?

If you manually set the page breaks, and then Group and print the WB, the
page breaks remain in force, and pick up their own page number.

So, if Sheet 1 had 3 *print pages*, and all the other 13 sheets had 1 each,
you'd end up with 16 page numbers.

What *exactly* are you looking to accomplish?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Adam" wrote in message
...
Some of the worksheets print over 3 pages, so grouping and then adding the
the footer removes the page breaks on those pages.

"RagDyeR" wrote:

Group your Worksheets before printing.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Adam" wrote in message
...
Hi All,

I've add the page footer pages # of # however on each page its coming up
with 1 of 1.

There are about 14 worksheets in the workbook so why isn't it showing 1 of
14 on the last sheet?


--
Adam
-----------
Windows 98 + Office Pro 97