Macro to list any formula that have a "Ref" in them

[tonywatsonhelp]

Hi Everyone,

I have a document that contains a lot of formulas,
I noticed that a few of then had been messed up and had the REF instead of the cell,
I'm worried this might be the case in other cells and im missing them

If its possible what would be great is to have a macro that runs and makes a list of any formulas that have the REF error instead of the cell (I mean in the actual formula, not in the result)
If the macro could create a new sheet and show me what sheet and what cell the errors are in this would be perfect.

Thanks

Tony

 

[jasonb75]

Instead of writing a procedure to find errors that may not exist, you could simply use Ctrl f to search the workbook for them.

Remember to set the option dropdowns to Workbook and Values.

 

[GWteB]

that have the REF error instead of the cell (I mean in the actual formula, not in the result)

Remember to set the option dropdowns to Workbook and Values.

In this case the Look In dropdown should be set to Formulas.

 

[jasonb75]

In this case the Look In dropdown should be set to Formulas.

Good catch, I misread that part.