Print form and increment A1 after printing.

[Harry Geda]

Hello,

I would like to use A1 as counter.
Use the value in the A1 as page number and other formatting in sheet and
then print the sheet if the number in A1 is laess than B1.

After printing increment A1 and check if it is larger than B1.
If not larger than B1 then let the form use the value in A1 do its setting
of the form and then print it.

If the A1 is greater than B1 then stop the printing
I can do manual saving of the file.
The file at this point should have the new values of A1 and B1.

Entering the file next time A1 is larger than B1.
I change the B1 to a new number and resume printing.
The code should print from the new A1 number and print until it is larger than B1.

I have posted something similar to this before but I could not make it work.
Please tell me which section is placed in Sheet1 and which code goes
in Module1 section.

If you think a Print button will make it easier then I welcome that.

Thank you,
Harry

 

[Harry Geda]

Interesting.
Not a single answer.
I solved it by looking in a few different Message Boards.

Harry

SOLVED