View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RajenRajput1 RajenRajput1 is offline
external usenet poster
 
Posts: 40
Default Check whether another sheet refers to cell in current

Dear All,

Many thanks for reading.

If I had a workbook with 10 sheets, labelled SheetA to SheetJ and wanted to
delete SheetA, I may have formulae in the other sheets which refer to cells
in SheetA, so I shouldn't delete it.

Is there any way to quickly check whether any other sheets from B-J have
formula references to SheetA. Obviously this will give me comfort for when I
delete it.

Many thanks

Rajen