View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Checking External Sheet References in formula

Does anyone know how to if a formula has an external sheet reference in it?
I am not concernced with external workbook references. I only want to know
if cell in say Sheet1 has any references to sheets other than Sheet1 in that
workbook.

Thanks