| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changed referenced cell between sheets
Niko,
what exactly do you mean? Tell us the formula in C24 and what do you mean by the referenced cell pointing to another cell. From the little I understood from your words, this is a behavior that can come about if a cell is deleted. E.g. If I have a formula =C18 and then one of the cells above is deleted, C18 moves up and now becomes C17. The formula will also change and will show =C17. Is this your case? Then I am not sure you can do much about it. Maybe though the layout is such that something can be fixed. At any rate, you have to be more specific. HTH Kostis Vezerides |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
| Sort referenced sheets together! | Excel Worksheet Functions | |||
| how to add many cells on diff. sheets and put in 1 cell in excel | Excel Worksheet Functions | |||
| cell shows 0 when referenced cell is null | Excel Worksheet Functions | |||
| in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
Threaded Mode
