title: ActiveWorkbook.Names.Add generates error "The syntax of this name isn't correct."
body: <p>This code has been working, now it is giving me:</p>
  
  <blockquote>
    <p>Run-time error '1004'<br>
    The syntax of this name isn't correct.</p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/kopU3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kopU3.png" alt="enter image description here"></a></p>
  
  <p>I think after the script runs I need to remove this saved name, however, I do not know how to do this.</p>
  
  <p>If after the debug error I start the code at the beginning of the with statement it works.</p>
  
  <pre><code>ActiveWorkbook.Names.Add Name:="MyList1", RefersTo:="=FlexInfo[Card Holder]"
  'RefersTo:="=TableName[ColumnHeader]"
  
  With Range("CardHold").Validation
       .Delete
       .Add Type:=xlValidateList, Formula1:="=MyList1" '&lt;Errors here
       .ShowError = False
  End With
  </code></pre>