Cells without dependent cells
Cells without dependent cells
(OP)
Is there any way within Excel, that on a given worksheet, it will show which cells (that have a formula) have no dependent cells?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Cells without dependent cells
|
RE: Cells without dependent cells
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Cells without dependent cells
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
Need help writing a question or understanding a reply? forum1529: Translation Assistance for Engineers
RE: Cells without dependent cells
RE: Cells without dependent cells
http://www.ozgrid.com/forum/showthread.php?t=73194
but note that I have not tried to test this code.
I found this by using a site I think I discovered through Eng-Tips:
http://www.jpsoftwaretech.com/vba-search-engine/
RE: Cells without dependent cells
Note also that if it is used ON THE SHEET then supplying a range as the argument CREATES a dependent cell or cells.
CODE -->