title: How do I clear a static variable in Excel VBA?
body: <p>I have a static variable defined in a Sub:</p>
  
  <pre><code>Private Sub assignVars()
  ' Use this function to assign default values
  
      Static isSet As Integer
  
      If isSet &lt;&gt; 1 Then
          ' do something
  
          isSet = 1
      End If
  
  End Sub
  </code></pre>
  
  <p>I have made some changes to my code and want to reset the static variable "isSet".  Is there any easy way to do this without closing Excel and opening it up again?</p>