View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Id'ing tabs that contain #REF!'s

I have a workbook with quite a few sheets, many having formulas that refer to
other sheets. Sometimes when I make changes to some of the cells in certain
sheets, I'll get #REF!'s on other sheets/cells. I'm thinking I'd like to have
a separate sheet that would show which sheets have #REF!'s., something like:

Sheet a! ok
Sheet b! Ref
Sheet c! Ref
Sheet d! ok

So I could easily goto that sheet and fix the #REF!.

Is that possible ?

Thanks,

Steve