Neill, By George (excuse the pun) I think we have it. Thank You very much for
your patience and help. You can't know how much it is appreciated.

I kind-of came to the same conclusion this morning about the manual print
range adjustments. That is probably it. I have opened/closed the workbook
numerous times (without making adjustments) and the formula has stayed. I now
have the sheets and workbook password rotected so the users can't mess it up
(although it does change if they manually change the print area). Perhaps
more security settings need to be checked/cleared, but that's another topic
if needed.

As a side note, I have the OFFSET formula type into a cell for cut/paste. In
that formula, I didn't type in the sheet reference so I can copy it and then
paste it into each sheet.

Thanks again for your help.
George

"neillcato" wrote:

>
> GeorgeW,
>
> In testing this works well for me as long as all of the cell references
> are absolute. Any manual methods of setting print area will overwrite
> the formula. I would stay away from the page break preview and use
> print preview instead.
>
> When you first open the workbook the print area selection is always
> missing. Run a print preview and you will see it will calculate
> correctly. You are right about the sheet references needed in the
> formula: they have to match the active sheet when you define the name.
>
> Ex:
> =OFFSET(Sheet3!$A$1,0,0):OFFSET(Sheet3!$A$1,COUNTA(Sheet3!$A:$A)-1,COUNTA(Sheet3!$8:$8)-1)
>
> Where "Sheet3" is the name of the active worksheet.
>
> I hope this helps.
>
> Neill
>
>
> --
> neillcato
> ------------------------------------------------------------------------
> neillcato's Profile: http://www.excelforum.com/member.php...o&userid=31750
> View this thread: http://www.excelforum.com/showthread...hreadid=514952
>
>