Alternative for Trace Precedents

Z

zen

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

Stefi

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:
 
Z

zen

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
 
S

Stefi

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:
 
Z

zen

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and Trace Return Cell 2
Dots on Trace Precedents Arrows 1
Trace Precedents and Dependents Arrows are Invisible 2
Code to format cells on several worksheets 2
Auto/conditional format 0
Excel needs a better interface to trace precedents and dependents 1
Word macro that can call cells out of Excel for a find and replace 0
Data Validation drop down not showing and Formula Auditing bar greyedout 2

Top