Hi all,

I have a working code which cycles through all the elements on a slicer and saves the same named range area as a PDF (with repeating header rows and footer). The file path and name are specified in cells so with one sheet selected it works great, but I would like to add a header page to tidy up the output, and for this I dont want the repeating rows and footer to appear. I have tried adding a second named range and activating both sheets but the code breaks when it gets to the slicer cycling section.

Any help on how I could add in this second sheet or named range as the first page would be much appreciated!

Thank you

HTML Code: