Printing Range Automatically
There is an Excel file that teaches how to perform the Printing Range Automatically operation.
Excel Printing Range Automatically
This workbook demonstrates printing range automatically using VBA macros on a 1-row data layout.
Hope it is useful.