Print Area as dynamic range?

  • Thread starter Michael.Tarnowski
  • 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
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Office Forms and dynamically updating the excel backend 0
Check Dynamic Named Range 5
Dynamic Named Ranges - is this possible? 2
Dynamic Range Defined by Value of Cell 7
Dynamic Named Range formula without using OFFSET function 5
concatenate dynamic ranges 7
Autofill a dynamic range with a formula. 1
Dynamic Named Ranges 3

Top