Amend Code for Printing

[mdot218]

Hi All

I use a spreadsheet to create pallet labels and check sheets.

There is one data entry sheet called 'Setup', where I input the quantity. This figure is then devided by 60. Eg if the figure was 222, then 4 pallet labels will be printed out: 1X60,1X60,1X60, and the "odd" pallet of 1X42, and 2 check sheets will be printed out too.

What I need it to do, is print out the 2 check sheets, and the odd pallet only (not to print the labels of 1X60)

I have tried unsuccesfully to ammend the VBA code, but cant get it to work without printing the labels of 1X60.

Attached is the sheet I use (I have changed names, so it is not case sensitive)

Thanks in advance

Regards