Stop Print_Area formula being converted to range when editing Page Setup
Using dynamic range formulas for PrintArea is extremely handy in many situations. However, when you edit any Page Setup options, the formula used for the PrintArea is converted to a normal range and the formula is lost.
I want to be able to edit the Page Setup options without having the Print_Area formula changed.
To avoid losing a complicated dynamic range formula, I define a new named range called printrange (with worksheet scope) and I set the PrintArea name to =WorksheetName!print_range.
I still need to remember to update Print_Area whenever I make a change to the page layout settings, but at least the dynamic range formula is not lost.
Arne Munther commented
This has been bugging quite a lot.
We've come across this problem too, with a non-macro spreadsheet that is used by multiple people in a company.