Wow, settle down guys. I meant no offence, and was just offering a
suggestion. I didn't know if you even considered that an option.

"dill_weed" wrote:

exactly - thank you harland. I am creating a template for others to use, and
I want entries to load automatically (referenced into several sheets), and
then be able to print easily - without making the user set a new print area
every for every single file that they create. As it is now, they will either
have to set a new print area every time they want to print a file, or if they
don't they will get several sheets of blank cells (because there are formulas
in them).

"Harlan Grove" wrote:

Sloth wrote...
What's wrong with using File-Print Area-Set Print Area

Nothing if you're the sort of person who likes to do everything
manually, but some people prefer that tasks that could be automated are
automated.