i have a workbook with a "roll-up" page that shows the results of all sheets between two "bookends"
for instance:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Tab/Sheet Name[/TD]
[TD]Purpose[/TD]
[/TR]
[TR]
[TD]Portfolio[/TD]
[TD]roll-up of all sheets between "<--" and "-->"[/TD]
[/TR]
[TR]
[TD]<--[/TD]
[TD]first bookend[/TD]
[/TR]
[TR]
[TD]Analysis 1[/TD]
[TD]individual analysis[/TD]
[/TR]
[TR]
[TD]Analysis 2[/TD]
[TD]individual analysis[/TD]
[/TR]
[TR]
[TD]-->[/TD]
[TD]end bookend[/TD]
[/TR]
[TR]
[TD]TEMPLATE[/TD]
[TD]template to create individual analysis sheets, users basically copy this tab between the bookends to add additional analyses to the portfolio.[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Tab/Sheet Name[/TD]
[TD]Purpose[/TD]
[/TR]
[TR]
[TD]Portfolio[/TD]
[TD]roll-up of all sheets between "<--" and "-->"[/TD]
[/TR]
[TR]
[TD]<--[/TD]
[TD]first bookend[/TD]
[/TR]
[TR]
[TD]Analysis 1[/TD]
[TD]individual analysis[/TD]
[/TR]
[TR]
[TD]Analysis 2[/TD]
[TD]individual analysis[/TD]
[/TR]
[TR]
[TD]-->[/TD]
[TD]end bookend[/TD]
[/TR]
[TR]
[TD]TEMPLATE[/TD]
[TD]template to create individual analysis sheets, users basically copy this tab between the bookends to add additional analyses to the portfolio.[/TD]
[/TR]
</tbody>[/TABLE]
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.