we have a sheet in which a vba program names specified cells so that another program can scrap result data
...
ActiveWorkbook.Names.Add Name:=RangeName, RefersTo:=RangeRe
...
we have had no trouble until recently when, mych to our anoiance we have been having problems inserting rows into the sheet. some of the names loose track of thier location, most do not, and this problem occurs only on one of the sheets in the workbook. is there a tool that checks for and potentially repairs invalid named cells. (we can predict which cells will falter because, even though they appear in tools like NameManager, when the cell in entered the cell location, rather than the cell name appears in the Name Box)

Thanks in advance