You could create a Custom View for each area that you want to print:
1. Set the print area for the first selection that you want to print
2. Choose View>Custom Views
3. Click the Add button.
4. Type a name for the view, e.g. Sheet1View1
5. Leave the checkmarks for Print Settings, and Hidden Rows
6. Click OK
After the views are created, use the Report Manager to automate the
printing process. (The Report Manager is an Add-In that you may have to
install. If it doesn't appear on the View Menu, choose Tools>Add-ins.
Select Report Manager, and click OK)
1. Choose View>Report Manager
2. Type a name for the Report
3. Select the sheet that contains the first view you want to print.
4. Select the View, click Add
5. Repeat steps 3 and 4 to add all the Custom views.
6. Click OK
To print a report, choose View>Report Manager
Select a report, click Print
