Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic print area based on cell value
I have researched the posts and found only a partial solution:
I want to use a cell value to dynamically determine the print area, I found the following: define name Print_area and use the formula: =INDIRECT(IF(DCIR!$D$114<3,"$A$1:$I$179",IF(DCIR!$ D$114<5,"$A$1:$I$241",IF(DCIR!$D$114<7,"$A$1:$I$30 3", IF(DCIR!$D$114<9,"A1:I365", IF(DCIR!$D$114<11,"A1:I427", IF(DCIR!$D$114<13,"A1:I489", IF(DCIR!$D$114<15,"A1:I551",)))))))) to identify the range. The issue is that I need to run this string to up to 3-47, odd numbers, but it it doesn't want to go beyond 15 without puking. Am I missing something? Is there a better way? Thanks M |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic print area based on cell value
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic print area based on cell value
Maybe you can use some arithmetic.
It looks like this may be equivalent: =INDIRECT("a1:I"&117+62*(CEILING(DCIR!$A$114,2)/2)) And just a reminder... You'll want to define Print_Area as a worksheet level name. Like: 'Sheet 99'!Print_Area wrote: I have researched the posts and found only a partial solution: I want to use a cell value to dynamically determine the print area, I found the following: define name Print_area and use the formula: =INDIRECT(IF(DCIR!$D$114<3,"$A$1:$I$179",IF(DCIR!$ D$114<5,"$A$1:$I$241",IF(DCIR!$D$114<7,"$A$1:$I$30 3", IF(DCIR!$D$114<9,"A1:I365", IF(DCIR!$D$114<11,"A1:I427", IF(DCIR!$D$114<13,"A1:I489", IF(DCIR!$D$114<15,"A1:I551",)))))))) to identify the range. The issue is that I need to run this string to up to 3-47, odd numbers, but it it doesn't want to go beyond 15 without puking. Am I missing something? Is there a better way? Thanks M -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Formula to govern Print Area | Excel Discussion (Misc queries) | |||
Extra Row in Defined Print Area | Excel Discussion (Misc queries) | |||
How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) |