printing blank forms with auto generated numbers

[Smurrock]

This seems like a simple macro function but I cannot figure out how to make
it work. I am trying to print inventory forms so I will need a lot of them
and to make sure we don't lose any I want them individually numbered. I used
a macro to auto generate a number for each form, 2 per page when they are
printed. My dilema now is that I need to be able to print, say 500 of them
at a time without hitting print 500 times.

My thought was a field to enter the qty needed that would drive the macro to
repeat itself x number of times......anyone have a function for this?
Thanks!

 

[Pete_UK]

I answered a similar post a few weeks back - take a look here:

http://groups.google.com/group/micr...fc7cf6badc20b63?lnk=gst&q=macro+pete+ashurst#

This was for 4 on a page, but it's the same approach.

Hope this helps.

Pete

 

[Smurrock]

Thanks, I'll have to check it out tonight since it's apparently blocked on my
work computer - figures since it's a work question..

 

[Pete_UK]

You're welcome.

Pete

 

[Gord Dibben]

Have a look at Ron de Bruin's site for printing multiple copies with
incrementing numbers.

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


Gord Dibben MS Excel MVP