View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Progressive number with Excel then print a unique Pdf file

Hi Mark,

Am Fri, 05 Jul 2013 20:38:36 +0200 schrieb Mark:

The content of the label is the same, except that I need to print the
label with a progressive number:
1 of 155
2 of 155
3 of 155
155 of 155
Is there a way with a macro to input the first (1) and last number (155)
and then print a Pdf files with 155 pages?
Then I'll print the Pdf in 4 copies (one each side of the pallet)


click in status bar "Page Layout". If you want the number e.g. top
right click in the right header and then in Header & Footer Tools on
Page Number, then write of and click on Number of Pages.
You can also put it in Footer, left, center or right.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2