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: 11
Default Using reviewing tools in macros



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
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
Keep macros from being ran under the tools option in the menu bar Jeremy Excel Discussion (Misc queries) 3 April 20th 10 08:42 PM
How do I get my macros from an XLA file to show in Tools Macro smartin Excel Worksheet Functions 0 June 28th 09 10:48 PM
Reviewing Large IF Statements - Any Tools available? BJ Excel Worksheet Functions 3 May 28th 08 09:38 PM
Macros not appearing in the Tools Macro Macros list hglamy[_2_] Excel Programming 5 October 24th 03 09:10 AM
List the Macros that can be executed from Tools-Macros Rob Bovey Excel Programming 1 July 10th 03 05:34 PM


All times are GMT +1. The time now is 11:38 PM.

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

About Us

"It's about Microsoft Excel"