Hi guys,

I'm new to VBA and I have this workbook where I have a command button which prints certain sheets to PDF, which contains below code:

Please Login or Register  to view this content.
I would like to be able to loop this code (the print to pdf part). It should change the cell value in cell Sheet1!D3, re-calculate the workbook and print to pdf with the settings in above code.

Cell D3 is a drop-down with a range of "Sheet2!J2:J11".

So basically the code should change cell Sheet1!D3 to the value in Sheet2!J2, calculate workbook, print to pdf and then loop until it have done this for all cell through to Sheet2!J11.

Can someone help with this?

Thanks a lot.

/stjuch