Hi Sam, Nice Answer. I wanted to ask this question before well doesn't matter to me, I got my answer.
regards Prince On Friday, August 3, 2012 9:34:10 PM UTC+5:30, Sam Mathai Chacko wrote: > > Trace Precendents and Trace Error is different from each other literally > as it sounds. For any single cell containing any formula, its precedents > are nothing but any cell or cells that it references in that formula. > > Trace Error on the other hand for any single cell containing any formula, > is the precedent cell or cells in that formula that have an error. > > So a cell traced using the Trace Error will always be a precedent cell of > that cell, but a cell traced using the Trace Precedents will not > necessarily have an error to be traced with the Trace Error feature. > > Regards, > Sam > > On Fri, Aug 3, 2012 at 8:42 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > >> * * >> >> *Hi Group,* >> >> * * >> >> *Is there any difference in Trace Precedents and Trace Error in Excel??* >> >> * * >> >> *I don’t need any link to see because I have already Google it.* >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> ** ** >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> >> > > > > -- > Sam Mathai Chacko > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
