ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I track down 'invalid references' (https://www.excelbanter.com/excel-programming/406043-how-do-i-track-down-invalid-references.html)

Dreiding

How do I track down 'invalid references'
 
I have a workbook that has many worksheets and associated formulas. Every
once in a while when I close the file I get the following message:
----------------------
A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain valid path, workbook, range name, and cell
reference.
-----------------------

I've been able to track this checking to be after "Workbook_BeforeClose"
execution, but I don't have a clue on finding the formulas with the invalid
references.
I found cells with "#DIV/0!", "#VALUE!", #NUM!, #N/A.
Which of these should I attach first? Could it be something else?

Any suggestions?


All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com