Excel Cell increase by 1 on each copy printed

[wrod7]

Hello all,

I having some difficulty increasing a cell by 1. If someone can help me.

I have this print to a label:

http://i50.tinypic.com/33e524i.png

I want C1 to increase by 1 for each copy printed. For example, when I click print and choose to print 5 copies. I want each label to have a different number, 1-5. Then after the print job is done, I would like it to go back to 1.


Thanks in advance.

[wrod7]

Just FYI,

I have a commandbutton on a different sheet that I click to print.

Here is the code it

Please Login or Register  to view this content.

Maybe somewhere in here we can add a line to +1 on C1?

[wrod7]

OK, I got it to print the way I want it to. Now I just need help being able to run this line of code X number of times.

How can I code this line to run X number of times?

ActiveWorkbook.PrintOut From:=937, To:=937, Copies:=1, Collate:=True

[JosephP]

Welcome to the forum. :-)

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

[ahjualune]

Welcome to the forums. I have in fact struggled with a very similar (but slightly more complicated problem). The solution to Your questions is here: http://www.excelforum.com/excel-prog...99#post2885699

Essentially what You need is a messagebox to ask how many pages you'd like to print

Please Login or Register  to view this content.

a will be the value entered on how many pages to print.