View Single Post
  #1   Report Post  
George
 
Posts: n/a
Default named range, offset self-reference

Excel 2002, XP Pro

I have a named range, (eg) X = WS!B2:F2,
and a formula in these cells (eg) B2 =A2+B1, which references a cell
(B1) that is offset in the same range.

Is there a way to use the range's own name (X) instead of B1 in this
formula?

Thanks,
George