Printing in Sequential Order

[Matt5353]

My active cell is A1. When I print I need the first number to be TCC-001 then TCC-002 then TCC-003 up to TCC-500
If I need to print some extra up to 600 after I have printed the first 500 what in the code would I need to change to make it start at TCC-501 up to TCC-600?
Thanks Andrew

 

[RoryA]

A gentle reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Printing Sequentially

I'm looking for help with some code for printing. My Active Cell is "A1" Every time I want to print the form it would be "TCC-001", TCC-002, TCC-003 up to 500 Thanks for any help My second question is if I needed to print extra copies later on is there a way to restart it at TCC-501 I presume...

chandoo.org

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.