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:

Tab/Sheet NamePurpose
Portfolioroll-up of all sheets between "<--" and "-->"
<--first bookend
Analysis 1individual analysis
Analysis 2individual analysis
-->end bookend
TEMPLATEtemplate 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.
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Forum statistics

Threads
1,214,795
Messages
6,121,624
Members
449,041
Latest member
Postman24

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