Is it possible or is it impossible?

[71paolo71]

Dear friends
Does anyone know how to set up page numbers in the footer that wil
print continuously across worksheets preserving the print area alread
made? I give you a example. I have 3 worksheets: WS1, WS2, WS3. I
every worksheet there are 3 pages to print. The print setting (prin
area) is already defined in each worksheet but, unfortunately, in pag
setup for each worksheet is defined a different scale (70% of norma
dimension, 65% and 68%). I would not change this scale I would like t
obtain this result:
WS1age1, WS1page2, WS1page3, WS2page4, WS2page5…..
I tried to select all sheets and to setup page number in the footer bu
the result was not good because the print area was changed.
Someone can help me?
Thank yo

 

[Tom Ogilvy]

This was answered the first time you asked it.

 

[NickHK]

Paolo
You can use a formula in the footer, like:
&[Page]+3 of &[Pages]+6

for the WS2, etc

NickHK

 

[pippo100]

I tried your solution Nick, but it doesn't work good.
If I have 40 sheets, and each sheet contains more pages to print (wit
different print setting scale), I should put a formula in the footer o
each sheet. It' s very long time and, as well, the print setting scal
was changed.
By my opinion, It's necessary a VBA code but I don't know how write it

Someone can help us?
By