If you have 4 worksheets of 5 pages each,
when you group them you will be printing.
Page # of ## (from the symbols)
page 1 of 20 through 20 of 20.
No programming required.
Does this have to be a programming solution,
and what page numbering do you actually want.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"71paolo71 " wrote in message ...
Dear friends
I have a file made by 4 sheets. Every sheet contains more pages to
print (the print area is already made). I would like to number all
pages and print them. is it possible to write a macro for doing it?
Thanks in advance for your help
---
Message posted from http://www.ExcelForum.com/