Hi,
I am trying to write code for a loop which does the following:

1.Change the value of cell A1 (to 1,2,3,4 etc. as it goes through the loop these numbers are in a range called List_numbers)
2. Save as the print_area to PDF in black and white
3. Save as to print_area to PDF in Colour
4. Repeat steps 2 and 3 until the end of List_numbers

The single cell which changes has 10 VLOOKUPs which depend on it so that each print out will be a different form for my overpaid plebians to complete when we do stocktake.

Any help would be greatly appreciated!