Excel wizards in here. Macro help!

[Kyle]

I use excel to print my invoices. I have a macro set up that automatically numbers the invoices. Every time you run the macro, it prints an invoice and increases the invoice number by one. I also attached the macro to a button so I don't have to tell it to run and keep pressing F5 to run it again. Instead I just have to click the button instead of opening the macro, etc. This is all fine and good, but I'm getting tired of having to click the mouse 250 times to run a whole set of invoices.

What I need is to figure out how to make it run so that the macro repeats 250 times and then stops. I have tried searching google multiple times looking for help, but could never get it to work right. Does anyone have any experience with this type of thing? Any help would be much appreciated!!!

[mustang_revival]

http://quickbooks.intuit.com/

[Kyle]

http://quickbooks.intuit.com/

Not much help there!

[Mr_Fiux]

momostallion = Wizard and ruler of all Excel Kingdoms.

[Nash B.]

For i = 1 To 250
[Your print stuff here]
Next i

[yellowstang]

Put a roll of nickles on the F5 key

[mustang_revival]

Not much help there!

I just brought it up b/c I helped my GF set this up for her small business and it works very well.

[momo]

momostallion = Wizard and ruler of all Excel Kingdoms.

hah, i wish i knew nothing about computers.

kyle, if you email it over to me at momostallion@gmail.com ill take a look at it.

[Kyle]

hah, i wish i knew nothing about computers.

kyle, if you email it over to me at momostallion@gmail.com ill take a look at it.

You've got mail!