G
George
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
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