Print Counter Macro

[hardrock14]

Ive got a label maker sheet that prints custom label templates to a label printer. I need a macro that does the following:

1. asks which printer to print to
2. asks how many copies to print
3. asks what number to start at
4. resets the number found in cell f2 (names "counter") to the start number input in step 3
should be formatted "00#"
5. prints that label (using print area)
6. adds 1 to the "counter" (f2) and prints that label.
this repeats until the number of copies specified in step 2 is satisfied. NOT until the counter matches the number in step 2.

I've pieced this together but its not working when I input anything besides "1' into step 3

Please Login or Register  to view this content.

Any help would be greatly appreciated

[JLGWhiz]

You are only assigning a value to the variable for the starting page. You would need to also tell the printer where to start if you are using the startcount variable as a page number reference.

Please Login or Register  to view this content.