excel97 page numbering issue.

[scroce]

Say you have 10 worksheets within a workbook.

Each worksheet contains 1 page worth of text.

You want to print all ten pages, with "1 of 10", "2 of 10",
"3 of 10".... etc in the right footer.

how do you do it?

for some reason Excel97 is not behaving consistantly. It keeps seeing each page as its own document, even when I try to group them. It keeps saying "1 of 1" on each.

I've tried a billion things. Nothing seems to work. to top it off, the footer seems to throw off the fomatting every time i try to implement it, so I'm wondering if I can just write some code that will count the worksheets and throw the number of each page in an empty cell on the sheet. - but i'm not sure where to start with the code.

anyone have any suggestions?

SC How much water would there be in the ocean if it weren't for sponges?

 

[Dreamboat]

File-Page Setup, make sure page numbering says auto. If it says 1, type Automatic or Auto (i forget).

File-Print-Workbook.


techsupportgirl@home.com

http://www.WeDoManuals.com

Brainbench MVP for Microsoft Word at

http://www.brainbench.com

 

[scroce]

ok, I had set it to "1" instead of "auto" in order to try to suppress printing of "page 1" on the first document, which is a cover page.

How do you suppress first page numbering (like in word)?

What would be optimal is that page numbering is suppressed on the first page, and the second page begins with "page 2" and then carries on sequentially from there. I know you are supposed to be able to modify the code to show something like &[page]+1, but that doesn't seem to do the trick.

Thank you for your post.

sc How much water would there be in the ocean if it weren't for sponges?