Still not Working: (List cells containing references to files, i.e. containing formulas with broken links) All of the cells contain broken links, i.e. links to a workbook that no longer exists. I want the macro to list the cell addresses of each of these cells. At the moment it does not detect it, even if the formula returns #Ref!. I am trying to attach a document for illustration but can not find the attach file button. Regards, vanhunk