-
print multiple sheets based on user choices
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules