Dear all,
First of all, thanks for any inputs/helps

I would like to create a macro to print an excel-sheet multiple times (based on input)
I have a file with the following sheets:
1) Table info
2) Letter

The table info can be seen as a big database. On the sheet Letter, i have some text and a number of vlookups to the "table info" sheet.

On the letter-sheets, in cell L1 holds the unique line-number, that fills the "letter" fully with the info i would like to print.
As I will be printing over 1000 letters, I have a start and end number in cells L4 (start) and L5 (end).

The macro that I would need (and I'm failing to create) should do the following when running.

It should look to the start number in L4. (say 10)
Put this number in L1 (so 10)

Print the letter (on Letter-sheet)

Put in L1 the next number following (so 11)
Print the letter (on Letter-sheet)

Put in L1 the next number following (so 12)
And so on, and so on, untill it reaches the End number, as stated in L5 (end).

----
So the number in L1 will always be in between L4 and L5.

It sounds very simple...when reading a again, unfortunatly I'm failing... any help is most welcome!
thanks,

Gerbs