I have a workbook with multiple sheets (20) and from time to time need to print various sets of the sheets other than a single sheet or the entire workbook. I have been trying to replicate the VBA code recorded from a manual selection of sheets to be able to select the names of the sheets in a list on my lead (summary) sheet. To date I have been completely unable to programmatically replicate the syntax that is recorded. I need to print them as a single print job to get consecutive page #'s for the printout for the entire set of sheets printed. I hope someone can help me. Here is the recorded code when selecting 2 of the sheets.
Any help will be greatly appreciated.
Please Login or Register to view this content.
Bookmarks