Print reference range of serial numbers into specified cell

hello people,

i'm currently figuring out a macro that prints 199 pages of the same worksheet, a template for a cover page of a vehicle maintenance record and i need the 199 pages to be printed with a different ID defined in a column of 199 cells, each with a unique number not in a sequential arrangement(i.e. 1001, 1002, 1003, ... x+1, x+1+1, ...etc)

Instead what I need to do is have the printed pages print from a series of data in a column as such:
1) 123
2) 369
3) 246
4) 135
5) 999
...
10) ###
etc and so forth till 199).
I've seen increments of +1 done fairly simply but i do not know how to adjust the macro to pring from a list of numbers.

I've done several google searches but I only found this as the nearest match to whhat I need.

Please Login or Register  to view this content.

This macro was for printing 2000 pages with a number set entered into cell A1.

This is my first time using VBA macros and I'm very unsure of the terms defined in macro.

I think this might be an easy one for me to learn, i hope someone could guide me on what to do.

Moderator Note:

Pls use code tags around your code next time as per forum rules.