I have code that works to pdf each worksheet as a separate pdf, but I want to add another worksheet each time, as the cover sheet. I cannot find a way to dynamically change the array to keep one sheet constant whilst looping through the other worksheets for the other sheet.

I’ve tried setting the array as Array(“Cover”,ws) and doing for each ws in this workbook but I get a ‘type mismatch’ error