Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I need to be able to tell if any of the used cells in column A do not have a cell which traces back to them. Basically I have cells in other sheets that link back to these, it is like a Bibliography or a works cited, only in Excel. I just need to make sure that everything I have included in my "Works Cited" has been linked to somewhere else. Using the record macro I have been able to develop something which brings up those stupid arrows, but I am looking for something that would provide me with feedback as to which cells do not comply. Maybe something that would highlight all of the cells which are used but do not have something linked to them. Anybody have any code that would do this? Or at least an idea for where I should start? Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Keep macros from being ran under the tools option in the menu bar | Excel Discussion (Misc queries) | |||
How do I get my macros from an XLA file to show in Tools Macro | Excel Worksheet Functions | |||
Reviewing Large IF Statements - Any Tools available? | Excel Worksheet Functions | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
List the Macros that can be executed from Tools-Macros | Excel Programming |