macro to select all sheets between two "bookends" and print them

gotmike

New Member
Joined
Jan 27, 2014
Messages
4
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:

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.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top