You could try doing a Find within a sheet, looking in formulas for:
=*!

This would find cells that contain formulas, and then a sheet reference.

Unless, of course, a defined name points to a cell on another sheet.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Wed, 7 Apr 2010 15:45:31 -0400, "Luke M"
wrote:

You could try doing a Find within a sheet, looking in formulas for:
=*!

This would find cells that contain formulas, and then a sheet reference.