Changing Cell Values (From and To) to Printer while Printing

How to send changing cell values to printer while printing? (VBA) Example: I have 2 type of documents that must be printing, document 1 is the page 1 and page 2 (From:= 1 To:= 2) and the third document is page 7 (From:= 7 To:= 7). I have set to change the cell values automatically, but the printer disobey the changing. So, the printer still print page 1 for third time. I hope anyone can help me.

Let's see the code

Please Login or Register  to view this content.

Range A1 and A2 values is changed automatically

I was thinking about this,
Would a loop work

Please Login or Register  to view this content.