i have a workbook with a "roll-up" page that shows the results of all sheets between two "bookends"
for instance:
<tbody>
</tbody>
i want to print all tabs EXCEPT the bookends and the TEMPLATE tabs.
i currently have something like this:
obviously, that won't work if the sheet names change.
is there a way to specify the "start" and "end" as a range here for selection?
another way to skin the cat might be to create a named range that uses a start/end but i'm not sure that's possible either.
for instance:
Tab/Sheet Name | Purpose |
Portfolio | roll-up of all sheets between "<--" and "-->" |
<-- | first bookend |
Analysis 1 | individual analysis |
Analysis 2 | individual analysis |
--> | end bookend |
TEMPLATE | template to create individual analysis sheets, users basically copy this tab between the bookends to add additional analyses to the portfolio. |
<tbody>
</tbody>
i want to print all tabs EXCEPT the bookends and the TEMPLATE tabs.
i currently have something like this:
Code:
Sub PrintAll()'
' PrintAll Macro
' Macro to print all relevant sheets...
'
'
Sheets(Array("Portfolio", "<-", "Analysis 1", "Analysis 2", "->")).Select
ActiveWorkbook.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False
End Sub
obviously, that won't work if the sheet names change.
is there a way to specify the "start" and "end" as a range here for selection?
another way to skin the cat might be to create a named range that uses a start/end but i'm not sure that's possible either.