Finding #REF errors in formulas in workbook

[GuyGadois]

I have moved a few things around in my workbook and have found a few #REF in some formulas. Is there a way I can find each cell that has a formula with an #REF? I got the #REF but referring to a cell or named range that no longer exists.

Thanks,

Guy

 

[dave3009]

Press F5, click on Special, choose formulas and uncheck all but errors press OK now all error cells are selected, you can maybe change the fill colour to make them prominent

 

[GuyGadois]

Perfect! Thank you.

Guy

(was in bonny Scotland this last summer. wonderful place)