How to: Define a Print Area
The table below lists a Worksheet object’s methods that allow you to set or clear a print area on a worksheet. A print area designates one or more cell ranges as the only region to print. A worksheet can have multiple print areas. Each print area is printed on a separate page.
|Worksheet.SetPrintRange||Defines a print area.|
|Worksheet.AddPrintRange||Adds cells to an existing print area.|
|Worksheet.ClearPrintRange||Clears a print area to print the entire worksheet.|
// Define a print area on a worksheet. Range printArea = worksheet["B1:F39"]; worksheet.SetPrintRange(printArea); // Enlarge the print area by adding adjacent cells. // An additional print area is created if you add non-adjacent cells to the print area. worksheet.AddPrintRange(worksheet["B40:F50"]); // Uncomment the following line to clear the print area and print the entire worksheet. // worksheet.ClearPrintRange();