Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trace all precedents or dependents
Hi,
Is there some code I can use to automatically trace all precedents or dependents of a cell? I.e., a macro or module which I can assign to a button? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
trace all precedents or dependents
They're readily available. ViewToolbarsFormula auditing
-- Kind regards, Niek Otten Microsoft MVP - Excel "Dave F" wrote in message ... | Hi, | | Is there some code I can use to automatically trace all precedents or | dependents of a cell? | | I.e., a macro or module which I can assign to a button? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
trace all precedents or dependents
That method required multiple clicks. I'm interested in code which I can
assign to a button, click once, and have the all of the cell's precedents or dependents displayed with tracer arrows. "Niek Otten" wrote: They're readily available. ViewToolbarsFormula auditing -- Kind regards, Niek Otten Microsoft MVP - Excel "Dave F" wrote in message ... | Hi, | | Is there some code I can use to automatically trace all precedents or | dependents of a cell? | | I.e., a macro or module which I can assign to a button? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
trace all precedents or dependents
if they are on the same sheet, look at the
directPrecedents directDependents Precedents Dependents properties of the range class. If they are off sheet or links, then it gets much much harder. -- Regards, Tom Ogilvy "Dave F" wrote: Hi, Is there some code I can use to automatically trace all precedents or dependents of a cell? I.e., a macro or module which I can assign to a button? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
trace all precedents or dependents
Thanks, Tom. For now I'm just thinking of precedents and dependents on the
same sheet... "Tom Ogilvy" wrote: if they are on the same sheet, look at the directPrecedents directDependents Precedents Dependents properties of the range class. If they are off sheet or links, then it gets much much harder. -- Regards, Tom Ogilvy "Dave F" wrote: Hi, Is there some code I can use to automatically trace all precedents or dependents of a cell? I.e., a macro or module which I can assign to a button? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
trace all precedents or dependents
My previous post doesn't show the arrows. To do that the easiest way to get
the code is to: Turn on the macro recorder (tools menu - macro - record a new macro) while you do it manually. Turn off the macro recorder. Then modify the recorded code to achieve those same results. -- Regards, Tom Ogilvy "Dave F" wrote: That method required multiple clicks. I'm interested in code which I can assign to a button, click once, and have the all of the cell's precedents or dependents displayed with tracer arrows. "Niek Otten" wrote: They're readily available. ViewToolbarsFormula auditing -- Kind regards, Niek Otten Microsoft MVP - Excel "Dave F" wrote in message ... | Hi, | | Is there some code I can use to automatically trace all precedents or | dependents of a cell? | | I.e., a macro or module which I can assign to a button? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
trace all precedents or dependents
Dave,
There is the ActiveCell.ShowDependents False which adds the next level of dependents' arrow each time you call it. I don't see an easy way to know when you have reached the end though. NickHK "Dave F" wrote in message ... Hi, Is there some code I can use to automatically trace all precedents or dependents of a cell? I.e., a macro or module which I can assign to a button? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel needs a better interface to trace precedents and dependents | Excel Discussion (Misc queries) | |||
Trace Precedents and dependents for a range of cell ? | New Users to Excel | |||
Trace Precedents and Dependents Arrows are Invisible | Excel Discussion (Misc queries) | |||
Trace Dependents and Precedents not working | Excel Worksheet Functions | |||
Trace Precedents / Dependents | Excel Programming |