That will work, but it does not meet either of your first two requirements.

1.) Require prompts that ask for a range of serial numbers (i.e. "What is the serial starting value?" "What is the serial ending value?")
2.) Prints the workbook with the starting serial number, increments the serial number and prints again. Continues to loop until the range as given in #1 is completed.

Did you try my code?