LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default Reference list

Hi all,
using excel 2007

If a cell has precedents and dependants ~
If I click on trace dependents once, it will show arrows to direct
dependants
If I click trace dependents more than once (till it beeps) it will expand
the arrows to all indirect dependancies
Is it possible to write a macro to show all dependancies in a list

Skinman

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reference List Gene L. New Users to Excel 1 August 27th 09 07:45 PM
How Can I reference a the * cell in a list? emanthey Excel Programming 1 August 27th 07 10:31 PM
List Reference Sam Excel Programming 3 July 3rd 07 12:32 AM
Removing a reference from the LIST BlueTrin Excel Programming 1 August 9th 06 05:47 PM
How to reference list using a drop down menu, displaying the list eddiespaghetti Excel Programming 0 January 4th 06 08:08 PM


All times are GMT +1. The time now is 04:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"