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!

I answered a similar post a few weeks back - take a look he

http://groups.google.com/group/micro...Bpete+ashurst#

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

Hope this helps.

Pete

On Feb 20, 2:42*pm, Smurrock
wrote:
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!

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" wrote:

I answered a similar post a few weeks back - take a look he

http://groups.google.com/group/micro...Bpete+ashurst#

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

Hope this helps.

Pete

On Feb 20, 2:42 pm, Smurrock
wrote:
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!

You're welcome.

Pete

On Feb 20, 3:17*pm, Smurrock
wrote:
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..

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

On Fri, 20 Feb 2009 06:42:19 -0800, Smurrock
wrote:

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!