View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Trace Dependents for range of cells

The trace dependents command works only on the active cell. If doing
several cells at once is important to you you could write a macro that does
it.

--
Jim
"violasrbest" wrote in message
...
| Hi
|
| I need to trace dependents in a range of cells rather than just one cell,
| but it doesn't seem to work. Am I missing something simple? I'm using
Excel
| 2002.
|
| Thanks
|
| VrB