finding references before deleting a sheet

**carsto** · 11-10-2006, 02:59 PM

I have a huge workbook my boss started and I'm finishing. (He does the data entry & I do the formulas - gotta love that!)
It's so full of garbage it's ridiculous.
Problem is, rather than start fresh with my own spreadsheet (which I keep telling myself I'll do next time....) I've built on his.
Now I need to get rid of the garbage.

Is it possible to find any cells containing formulas referring to a sheet before deleting the sheet?

Thanks

**VBA Noob** · 11-10-2006, 03:02 PM

Hi,

Try this link which has some VBA code

http://www.j-walk.com/ss/excel/tips/tip37.htm

VBA Noob

**carsto** · 11-10-2006, 03:06 PM

I know nothing about VBA code

well, I should try first then reply!
I opened VBE inserted a module and voila a macro appeared.

THANKS! Just wish I understood what all that verbiage meant......

**VBA Noob** · 11-10-2006, 03:14 PM

Hi,

Try these sites

http://www.contextures.com/xlToolbar02.html#Setup

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Non VBA way is Tools > options > View and tick Formulas or

Tools > Forumla Auditing > formula auditing mode

VBA Noob

**carsto** · 11-10-2006, 03:20 PM

THANKS for the links

finding references before deleting a sheet

LinkBack

Thread Tools

Rate This Thread

Display

finding references before deleting a sheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions