I'm writing a macro that prints out certain ranges and certain worksheets in a workbook based on user choices. I'd like to make use of this code:

Sub
PrintSheets()

Dim aShtLst As Variant
aShtLst = Array(?Sheet1″, ?Sheet2″, ?Sheet3″)
ThisWorkbook.Sheets(aShtLst).PrintOut
End Sub


My idea was to create cell that dynamically outputs ("Sheet1", "Sheet2", "Sheet3") and pass that value to the Array. The Array doesn't like that, however. Any suggestions?