Hi,
The dependents property of a Range object only returns dependen
cells on the same worksheet. How do I collect dependent cells on othe
worksheets?

And what is the difference between Dependents and DirectDependents?

Thanks.

Teres

--
Message posted from http://www.ExcelForum.com