Print Area seems to be stuck on a previous Range, or print area, and will only print one page of a series. I have had to select (the cells for) each required print page individually, and print (pdf) each page individually (to be assembled later into the required multi page document Any ideas?
I have tried to Save As, but with no benefit. Note: the spreadsheet has numerous rows ‘hidden’ via Column Filters. IE the spreadsheet has 480 rows, but only 154 rows are to be printed.
The selections do not include Column A
UPDATE: I have tried removing all filters, and this allowed me to select and print all paages, IE all 480 rows, so this has removed the ‘one page’ restriction. I then applied the filters again, and the restriction returned. So, any ideas?