WorkSheet Cell Precedents?

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Excel2003 ... I wish to delete a few WorkSheets in a 40mg WorkBook ...
However, I do not wish to delete if any of the cells are Precedent for other
WorkSheets.

I know how to do this on a cell basis with the "Auditing" ToolBar ... but is
there a way to do this on a WorkSheet basis.

Thanks ... Kha
 
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.
 
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.
Click to expand...

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
 
Luke/Chip ... (Good morning)

FYI ... I learn the simplest of helpful things everyday ...

Thank you for supporting these boards ... Kha
 
Back
Top