Specifying a Print Range
To specify a block of cells as a print range
To specify a range of pages as a print range
Overview
You can specify either a block of cells or a range of pages as a print range.
Note: If you have set the ColsFrozen or RowsFrozen property to freeze columns or rows, the frozen columns or rows will also print with your range, even if they are not included in the range you specify. |
You can also specify that only the columns and rows that contain data in the sheet are printed. For more information, see Printing the Portion of the Sheet with Data