Sequential page numbers for one page  
Index ‹ Excel ‹ Excel
Author Message
Luffers
PostPosted: Tue Mar 08 10:05:19 CST 2005 Top
Excel >> Sequential page numbers for one page

I have to print forms made in excel with sequential numbering. Every copy
will be identical, except for the page number. It would be preferential to
have the numbers preceded by a common letter.
I can't find anything in help for this. Can it be done?

Excel259  
 
 
Ron
PostPosted: Tue Mar 08 10:05:19 CST 2005 Top
Excel >> Sequential page numbers for one page Hi Ivan

http://www.rondebruin.nl/print.htm#number

If you need more help post back


--
Regards Ron de Bruin
http://www.rondebruin.nl




>I have to print forms made in excel with sequential numbering. Every copy will be identical, except for the page number. It would
>be preferential to have the numbers preceded by a common letter.
> I can't find anything in help for this. Can it be done?
>


 
 
Ivan
PostPosted: Thu Mar 10 21:06:25 CST 2005 Top
Excel >> Sequential page numbers for one page Ron, thanks for the link to that. I'm far from an expert at excel. Where
do I type that formula?



> Hi Ivan
>
> http://www.rondebruin.nl/print.htm#number
>
> If you need more help post back
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>


>>I have to print forms made in excel with sequential numbering. Every copy
>>will be identical, except for the page number. It would be preferential
>>to have the numbers preceded by a common letter.
>> I can't find anything in help for this. Can it be done?
>>
>
>


 
 
Ron
PostPosted: Fri Mar 11 00:17:44 CST 2005 Top
Excel >> Sequential page numbers for one page Hi Ivan

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you use Alt-F8 you get a list of your macro's
Select "PrintCopies_ActiveSheet" and press Run





--
Regards Ron de Bruin
http://www.rondebruin.nl




> Ron, thanks for the link to that. I'm far from an expert at excel. Where do I type that formula?
>

>> Hi Ivan
>>
>> http://www.rondebruin.nl/print.htm#number
>>
>> If you need more help post back
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>

>>>I have to print forms made in excel with sequential numbering. Every copy will be identical, except for the page number. It
>>>would be preferential to have the numbers preceded by a common letter.
>>> I can't find anything in help for this. Can it be done?
>>>
>>
>>
>
>


 
 
 
Index ‹ Excel ‹ Excel