One worksheet only.
First 10 rows are static including headers at row A10:AT10 and BA10:BT10. Below each range are 100 rows with different objects.
When printing with code below, only the first page of A10:AT10 will have headers (correctly), page 2-3 don't have any headers.
Then page 4 of BA10:BT10 (correctly) will have headers but not page 5 and 6.
This makes it hard to see on page 2-3 and 5-6 what header each column has.
1) Is it possible for each page to repeat the area from A2:AT10 and BA2:BT10?
2) Also, is it possible to include some kind of page number at the bottom right or top right?
Bookmarks