Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 Dynamically Set Print Area
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 Dynamically Set Print Area
Tom Farrell wrote:
Is there a way to adjust this offset to disregard the cells with forulas and set the print area to just imported/filled data? Try replacing COUNTIF(Sheet2!$A:$A,"<") with COUNTA(Sheet2!$A:$A)-COUNTIF(Sheet2!$A:$A,"") Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted | Excel Worksheet Functions | |||
split print area in excel - One Page Print | Excel Worksheet Functions | |||
How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
How to Dynamically Set Print Area | Excel Discussion (Misc queries) |