I have the OFFSET command working now in multiple sheets. [I had a bit of a
problem getting the 'sheet name!' to be correct on each sheet but have that
now.] Remaining problem is that the OFFSET command sometimes getting replaced
by the absolute cell references (the results) when the workbook is closed. It
doesn't do it all the time and I haven't quite figured out what makes it
occur. If it won't stay then all this work is for nothing.
Any thoughts on where to look???

"GeorgeW" wrote:

> This works for 1 sheet but always adds the sheet name in quotes to the
> formula. Then it can't work on the other sheets because they aren't the same
> size as the first sheet where the formula was defined in.
> To simplify/clarify: Sheet1 is 5x5; Sheet2 is 7x7; Sheet3 is 10x10.
> If I define the Print_Area in Sheet1 then all sheets are sized to 5x5. I
> would like to have each sheet have their own size definition.
>
> Thanks For getting me this far. I'm excited that it works this well.
>
> PS One other minor bug found in testing: the show page breaks follows the
> print area when reducing the number of columns (by taking out a value in row
> 8). When I put a value back in it doesn't get larger but does change if I do
> a print preview. F9 doesn't make it recalculate this formula. So long as it
> works this is a minor detail.
>
> "neillcato" wrote:
>
> >
> > George,
> >
> > Define the name "print_area" and paste this formula where it says
> > "refers to". Repeat this for each of the six sheets - the column range
> > is dynamic based on row 8 as in your previous example:
> >
> > =OFFSET($A$1,0,0):OFFSET($A$1,COUNTA($A:$A)-1,COUNTA($8:$8)-1)
> >
> >
> > Neill
> >
> > PS - note that the value 0 is counted by the function COUNTA
> >
> >
> > --
> > neillcato
> > ------------------------------------------------------------------------
> > neillcato's Profile: http://www.excelforum.com/member.php...o&userid=31750
> > View this thread: http://www.excelforum.com/showthread...hreadid=514952
> >
> >