Print multiple pages based on cell value to pdf

[lpratt]

I am looking for a code that will print multiple sheets and combine into pdf based on a cell values on "header" page.

The name of the combined pdf should be what is in cell a1 on 'HEADERPAGE" eg:
random stuff pricing today.PDF

there should be no location set as this will change so a 'Saveas' type option is best.
hope this makes sense.

Please see attached file

[6StringJazzer]

Your labels are irregularly spaced from the count boxes, which complicates matters. I moved them so they would all be the same.

Also the labels must exactly match the sheet names so I renamed sheet Apple to Apples.

there should be no location set as this will change so a 'Saveas' type option is best.

I have no idea what you mean by this. There is no SaveAs option in VBA for exporting PDF files.

[lpratt]

Wow! thank you 6StringJazzer that is spot on

[lpratt]

oh no it has stopped working now that i have added sheets.

please can you advise on what's wrong here?

i am so lost.

[6StringJazzer]

Here is what I said:

Your labels are irregularly spaced from the count boxes, which complicates matters. I moved them so they would all be the same.

You moved them back again. So it won't work.