WorkSheet Cell Precedents?

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
 
L

Luke M

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.
 
C

Chip Pearson

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
 
K

Ken

Luke/Chip ... (Good morning)

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

Thank you for supporting these boards ... Kha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top