Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default To number/print pages

Dear friends
I have a file made by 4 sheets. Every sheet contains more pages t
print (the print area is already made). I would like to number al
pages and print them. is it possible to write a macro for doing it?
Thanks in advance for your hel

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 691
Default To number/print pages

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/




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number of pages in worksheet doesn't match Print Preview pages delru Excel Discussion (Misc queries) 2 May 10th 10 10:08 PM
how can I permanently overide the number of pages set to print? confused Excel Discussion (Misc queries) 2 January 31st 08 04:47 PM
need a print macro to print only a certain number of pages Tonso Excel Discussion (Misc queries) 2 July 26th 06 06:03 PM
How do I set a macro to print variable number of pages in excel? Livio Excel Discussion (Misc queries) 1 July 30th 05 12:15 AM
How to print a worksheet but number the pages by workbook Frank Clayton Excel Discussion (Misc queries) 2 January 10th 05 10:52 PM


All times are GMT +1. The time now is 06:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"