selecting multiple sheets from a list based on cell value and creating pdf

  • i have a list of sheets and in front a checkbox symbol is there whoose value is R

    i need a code that selects all the sheets whose checkbox is R and create a pdf for all the selected sheets combine. here is my code but it is giving error subsript out of range on sheets(sharray).select

  • Can you attach a small example workbook.

    Also, please take the time to read the Forum Rules. I have added Code Tags to your post, the rules will explain how and why.

  • On the off chance that I understand what you want.

    Top Row (Row 1) is a Header Row

    The 3rd Column ("C") has the "R"'s in it.

    The respective Sheet Names are to the left of it in Coulumn B

    If the respective Sheet Names are to the right of the "R"'s, in Column D, the -1 in the 6th and 8th line of the code needs to be changed to just a 1.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!