Static Cenll

[WayneB]

Hi: I have a cell D38 that is used in many formulas in its sheet and other
sheets. The problem is every two weeks I have to delete column D. D38
disappears -- even when I refer to $D$38 -- so I have to rebuild all the
referring formulas. Any ideas? thx wayne

[JE McGimpsey]

Try

=INDIRECT("D38")

In article <exrSZdgDFHA.3452@TK2MSFTNGP09.phx.gbl>,
"WayneB" <jburritt@bellsouth.net> wrote:

> Hi: I have a cell D38 that is used in many formulas in its sheet and other
> sheets. The problem is every two weeks I have to delete column D. D38
> disappears -- even when I refer to $D$38 -- so I have to rebuild all the
> referring formulas. Any ideas? thx wayne

[Arvi Laanemets]

Hi

P.e.
=OFFSET($A$1,37,3)

Arvi Laanemets


"WayneB" <jburritt@bellsouth.net> wrote in message
news:exrSZdgDFHA.3452@TK2MSFTNGP09.phx.gbl...
> Hi: I have a cell D38 that is used in many formulas in its sheet and
other
> sheets. The problem is every two weeks I have to delete column D. D38
> disappears -- even when I refer to $D$38 -- so I have to rebuild all the
> referring formulas. Any ideas? thx wayne
>
>