Setting Print with Macro
There is an Excel file that teaches how to perform the Setting Print with Macro operation.
Excel Spreadsheet for Setting Print with Macro
This workbook defines print areas and settings using VBA on a simple three-row page layout.
Hope it is useful.