title: Assigning the value of a variable to a defined Name
body: <p>I am trying to create a worksheet defined name "Token" and I need it to refer to the value of Access_Token Variable. Lets say Access_Token = "This is a Token".</p>
  
  <p>Then I would like the Defined Name to be set to "This is a Token".
  I have tried the following code:</p>
  
  <pre><code>ActiveWorkbook.Names.Add Name:="Token", RefersTo:=Access_Token
  </code></pre>
  
  <p>I can do it as follows:</p>
  
  <pre><code>ActiveWorkbook.Names.Add Name:="Token", RefersTo:="=This is a Token"
  </code></pre>
  
  <p>But I am getting "Runtime 1004 Error".</p>
  
  <p>Does anyone know the syntax?</p>