ExcelBanter - Checking External Sheet References in formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Checking External Sheet References in formula (https://www.excelbanter.com/excel-programming/334622-checking-external-sheet-references-formula.html)

ExcelMonkey

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

All times are GMT +1. The time now is 06:47 AM.