View Single Post
  #1   Report Post  
David Iacoponi
 
Posts: n/a
Default Some 'Names' cannot be deleted by Insert|Name|Define-Delete button

(Excel 2000) we have spreadsheets with Names that somehow have square boxes
in front of them that we cannot delete with the macro we use, or with the
manual Delete button. As an aside, we can't edit the value associated with
the name, which might look like this
='R:\GENERAL\[MODEL_A1.XLS]DIAMOND'!#REF! Suggestions on how to do this via
VBA appreciated.