View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aaron Cooper Aaron Cooper is offline
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!