Hoping someone here can help me write a routine that would create a multipage pdf from one print range. this would be written onto a command button.

I have a worksheet with several charts. this worksheet also has a scrollbar that scrolls through the x-axis range on all the charts.
Basically i want to pdf the print range of this worksheet several times to end up with one pdf in the end...but change the scroll bar value in between each page print.
Essentially:
-set scrollbar value to minimum
-pdf the page
-increase scrollbar value by .LargeChange
-pdf the page
-increase scrollbar value by .LargeChange
-pdf the page
...do this until scrollbar value is maximum and then have the window popup that prompts user for the file name & save location of the final pdf.

I hope this makes sense.