View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default 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.