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