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