Non Macro solution to Set Print Area to a table

[High Plains Grifter]

Is there any non-macro way to ensure that the print area of a worksheet expands as more rows are added to a table? I can add a macro to do it but the file is shared by many and is large - people may not all know to enable macros and an on change macro might slow things up a bit.

Any ideas or feedback much appreciated,

 

[shg]

If you simply clear the print area, everything will print.

 

[High Plains Grifter]

The simple answers are the best I take it then that there are no more cunningly precise methods of dynamic print areas without macros. I'll move all the gubbins I don't want to print onto another sheet I guess and carry on as before.

Thanks for the answer!