sequential numbering when printing

[rml2n]

Hi,
I am working on a regular excel spreadsheet that I need to print
hundreds of. However, when i print the spreadsheet, they all need to
be identical with the exception of the page number for reasons of
record. I would like to have sequential numbering starting at
1....300, 301 and so on. Is there any way i can do this without
having to use a macro or any type of code? I am not exactly good at
any of that kind of thing.

thanks,
ryan l

 

[Pete_UK]

If you visit this site, though, JE gives two approaches to achieve
this (the text file approach may be better for you):

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

so you don't have to do much coding yourself.

Hope this helps.

Pete

 

[Gord Dibben]

Is it just one printed page and you want to print many copies of the same page?

See Ron de Bruin's site for macro code to do this.

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

If you're not familiar with VBA and macros, see David McRitchie's site for
more on "getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

or Ron de De Bruin's site on where to store macros.

http://www.rondebruin.nl/code.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + r to open Project Explorer.

Find your workbook/project and select it.

Right-click and Insert>Module. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run or edit the macro by going to Tool>Macro>Macros.

You can also assign this macro to a button or a shortcut key combo.


Gord Dibben MS Excel MVP