View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Dean[_8_] Dean[_8_] is offline
external usenet poster
 
Posts: 407
Default Trace Dependents

Sounds like a plan. Thank you!

D

wrote in message
oups.com...
Hi Dean.

If so, this is a bit scary. I am in the habit of deleting cells that

have
no dependents, to clean up worksheets. This may need to be a habit

I'll
have to break! Yikes!


What I usually do in such a process is:

- Save all files open (I tend to have external lins involved as well)
- Then delete the range of cells i suspect is unused
- Then run my Flexfind utility to find out whether any #REF! error(s)
have occurred. Flexfind is capable of searching almost any object in
Excel that may have a reference to a cell. Find Flexfind he

http://www.jkp-ads.com/OfficeMarketPlaceFF-EN.htm

Regards,
Jan Karel Pieterse
Excel MVP
www.jkp-ads.com