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

  • 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.