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.
|