Print Area as dynamic range?

  • Thread starter Thread starter Michael.Tarnowski
  • Start date Start date
M

Michael.Tarnowski

Hi community,
it is possible to define the print area as a dynamic range, thus
always a certain range is covered?
Cheers Michael
 
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),COUNTA(Sheet2!$1:$1))

to set the range of Print_Area
 
Back
Top