| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automaticaly entering static dates | Excel Discussion (Misc queries) | |||
| Can I create a static link between Excel and Outlook contact data. | Excel Discussion (Misc queries) | |||
| Hyperlinks static but formulas are not. Why? | Excel Discussion (Misc queries) | |||
| Help creating a formula, pulling from a set of static numbers. | Excel Worksheet Functions | |||
| Static Dates in Footers | Excel Worksheet Functions | |||
Hybrid Mode
