Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternative for Trace Precedents
Value of cell A1 is changing if changes are made on the worksheet, so this
means that A1 is reading values of various cells. The problem is that A1 is named so I cannot see what is defined and even TRACE PRECEDENTS is not helping. Want to know how can i see what is defined in A1, any help will be welcomed. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternative for Trace Precedents
It seems that there is a Change event macro in your workbbook. Check it by
pressing Alt+F11 (VBA),. right click on the worksheet name in the Project explorer window, select View code from the local menu! Regards, Stefi zen ezt *rta: Value of cell A1 is changing if changes are made on the worksheet, so this means that A1 is reading values of various cells. The problem is that A1 is named so I cannot see what is defined and even TRACE PRECEDENTS is not helping. Want to know how can i see what is defined in A1, any help will be welcomed. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternative for Trace Precedents
Hey Stefi,
Thanks for you help but i tried doing this and it didn't work. I just want to know what is defined in that cell. Can it be anything else because this is really new to me. Thanks "Stefi" wrote: It seems that there is a Change event macro in your workbbook. Check it by pressing Alt+F11 (VBA),. right click on the worksheet name in the Project explorer window, select View code from the local menu! Regards, Stefi zen ezt *rta: Value of cell A1 is changing if changes are made on the worksheet, so this means that A1 is reading values of various cells. The problem is that A1 is named so I cannot see what is defined and even TRACE PRECEDENTS is not helping. Want to know how can i see what is defined in A1, any help will be welcomed. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternative for Trace Precedents
Maybe it's simpler than I thought! Isn't there a formula in A1? What do you
see in formula bar when A1 is selected? Stefi zen ezt *rta: Hey Stefi, Thanks for you help but i tried doing this and it didn't work. I just want to know what is defined in that cell. Can it be anything else because this is really new to me. Thanks "Stefi" wrote: It seems that there is a Change event macro in your workbbook. Check it by pressing Alt+F11 (VBA),. right click on the worksheet name in the Project explorer window, select View code from the local menu! Regards, Stefi zen ezt *rta: Value of cell A1 is changing if changes are made on the worksheet, so this means that A1 is reading values of various cells. The problem is that A1 is named so I cannot see what is defined and even TRACE PRECEDENTS is not helping. Want to know how can i see what is defined in A1, any help will be welcomed. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternative for Trace Precedents
In the formula bar I just see the results of the formula, as any other number
keyed. In the Name Box, the name of the cell. The formula seems to be hidden and I want to see the formula. "Stefi" wrote: Maybe it's simpler than I thought! Isn't there a formula in A1? What do you see in formula bar when A1 is selected? Stefi zen ezt *rta: Hey Stefi, Thanks for you help but i tried doing this and it didn't work. I just want to know what is defined in that cell. Can it be anything else because this is really new to me. Thanks "Stefi" wrote: It seems that there is a Change event macro in your workbbook. Check it by pressing Alt+F11 (VBA),. right click on the worksheet name in the Project explorer window, select View code from the local menu! Regards, Stefi zen ezt *rta: Value of cell A1 is changing if changes are made on the worksheet, so this means that A1 is reading values of various cells. The problem is that A1 is named so I cannot see what is defined and even TRACE PRECEDENTS is not helping. Want to know how can i see what is defined in A1, any help will be welcomed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trace dependants/precedents from another worksheet | Excel Discussion (Misc queries) | |||
Trace Precedents Arrows Missing | Excel Discussion (Misc queries) | |||
Trace Precedents and Dependents Arrows are Invisible | Excel Discussion (Misc queries) | |||
Trace Dependents and Precedents not working | Excel Worksheet Functions | |||
I want to trace the precedents in a formula when they are on mult. | Excel Discussion (Misc queries) |