Select Sheets based on named range list of sheet names

[cchen212]

Hello. I am trying to create a macro that would select all the sheets listed in a range. The range is called "PrintList" but when I could only get the macro to work when I have the range rather than a named range.

How do I modify C22:C44 to be "PrintList"?

Sub Select_Sheets_To_Print()
    Dim sheetArray() As String
    Dim i As Integer
    i = 0
    For Each c In Range("C22:C44").Cells 
        ReDim Preserve sheetArray(0 To i)
        sheetArray(i) = c.Value
        i = i + 1
    Next
    Sheets(sheetArray).Select
End Sub