ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   variable print areas same worksheet (https://www.excelbanter.com/excel-programming/419154-variable-print-areas-same-worksheet.html)

joemeshuggah

variable print areas same worksheet
 
is it possible to set multiple print areas (variable in range) to a
worksheet, and for each area set, have the title rows specific to each area
print on each page?

example

rows a-b with column header top performers set to print area a
rows y-z with column header needs improvement set to print area b

both sets of rows are on the same worksheet, yet when printed rows a-b print
with column header top performers printing on each page

a page break separates printing for the next set of rows and y-z print with
header needs improvement on each page.


All times are GMT +1. The time now is 03:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com