I think I see your point now. I am naming entire rows that are out of range
when looking for -2 columns. I assumed that the named range would carry the
logic of address with it as if I were referencing the cell (=namerange) which
would give me the cell's value that corresponds with exact column placement
on a different worksheet.

It still puzzles me why the =offset(namerange,0,0,,) would work as if I just
typed =namerange but that =offset(namerange,0,-2,,) will not.

"arno" wrote:

> Hi StanJ,
>
> > The normal cell reference (=e69-c69) returns the correct answer.
>
> ok.
>
> what ist the adress of the top-left-cell of range "namerange"?
> what ist the result of
> =OFFSET(namerange,0,0,,)
> and
> =OFFSET(namerange,0,-2,,)
> and
> =row(namerange)
> and
> =column(namerange)
>
>
> arno
>