Dynamic Print Range

[l_eonandr]

Please help if anyone has any ideas;
I have set up an offset to make my print range dynamic (Offset($F$1,o,o,$J$1,4) so as the table expands the print range expands. CountA(I:I)+4 is in J1 to get row count. This works great, however, each month I copy the table and insert the copy in front of the old one then fill with data. I need for the print range to keep the $F$1 in the Offset.
It does not. The $F$1 changes to the new column the table moved to. The print range moves with the old table to the new columns the old table now occupies.
Is there a way of keeping the same columns in the print range, Ie old columns F:I, move table to right 5 columns, now new print range should be F:I, however excel has moved it to follow the table to K-N.
How can I set it for F:I and keep that even when columns are added in front of it? Is it possible?

 

[pbornemeier]

INDIRECT function should do it:

=OFFSET(INDIRECT("Sheet1!$F$1"),0,0,COUNTA(INDIRECT("Sheet1!$J:$J"))+4,4)

and you can also put the value you are calculating in J1 into the formula as well

 

[l_eonandr]

INDIRECT function should do it:

=OFFSET(INDIRECT("Sheet1!$F$1"),0,0,COUNTA(INDIRECT("Sheet1!$J:$J"))+4,4)

and you can also put the value you are calculating in J1 into the formula as well

Thank you, that work perfectly except I needed to change the count column. The formula to count was in J1 and referred to column I, so I just changed J to I and ...
Worked like a charm.
It didn't dawn on me to use indirect inside of offset.

Thanks again