ExcelBanter - Static Cenll

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Static Cenll (https://www.excelbanter.com/excel-worksheet-functions/12170-static-cenll.html)

WayneB

Static Cenll

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 ,
"WayneB" 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" wrote in message
...
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

All times are GMT +1. The time now is 11:11 AM.