When you set the print area, Excel creates a named range Print_Area... I
guess if you can make that dynamic you can get what you want...

Use something like
=OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$A:$A),COUNT A(Sheet2!$1:$1))

to set the range of Print_Area


"Michael.Tarnowski" wrote:

Hi community,
it is possible to define the print area as a dynamic range, thus
always a certain range is covered?
Cheers Michael