T
Tom Farrell
I have used the following solution several times successfully to
dynamically set a print area, but am having a problem with a sheet
that has formulas to populate data from another sheet. Is there a way
to adjust this offset to disregard the cells with forulas and set the
print area to just imported/filled data?
Insert=>Name=>Define
in the name box
Sheet2!Print_Area
in the refers to box:
=OFFSET(SHEET2!$A$1,0,0,COUNTIF(SHEET2!$A:$A,"<>"),COUNTIF(SHEET2!$1:$1,"<>"))
TIA
Tom Farrell
dynamically set a print area, but am having a problem with a sheet
that has formulas to populate data from another sheet. Is there a way
to adjust this offset to disregard the cells with forulas and set the
print area to just imported/filled data?
Insert=>Name=>Define
in the name box
Sheet2!Print_Area
in the refers to box:
=OFFSET(SHEET2!$A$1,0,0,COUNTIF(SHEET2!$A:$A,"<>"),COUNTIF(SHEET2!$1:$1,"<>"))
TIA
Tom Farrell