You need to have at least a couple of steps like:
1. let user to input minimum number 1 and maximum number 10 in your case, and assign each of these values to variables intMin and intMax;
2. have procedures to run your business logic (print the report and then clear the input values for the next new report); and,
3. format the print settings.
I'd suggest you use the record macro function to record your setps first, then modify the vba scripts.
1. let user to input minimum number 1 and maximum number 10 in your case, and assign each of these values to variables intMin and intMax;
2. have procedures to run your business logic (print the report and then clear the input values for the next new report); and,
3. format the print settings.
I'd suggest you use the record macro function to record your setps first, then modify the vba scripts.