title: Excel VBA Public Dictionary object auto populating?
body: <p>Have 2 Dictionary objects I'm using, declared Public bc I need them to persist outside each sub i use them in, but for some reason they're auto populating before I even load them up. Has anyone see this behavior?</p>
  
  <pre><code>Public itmsSpot As Dictionary, itmsFwd As Dictionary
  
  Public sub runReport()
    Set itmsSpot = New Dictionary
    Set itmsFwd = New Dictionary
  
    GenData
  
  End Sub
  
  Public Sub GenData
  ...
  </code></pre>
  
  <p>GenData loops thru a sheet in my workbook and populates itmsSpot and/or itmsFwds depending on the data in the sheet, but for some reason it's adding values into one or both as soon as it steps into GenData before it even starts to loop thru the sheet.</p>
  
  <p>I've tried <code>Set itmsSpot = Nothing</code> just before I call GenData, but it doesn't quite do the trick. Even if I wipe out the data in the sheet, it seems to autopopulate from the last time I ran it. Any thoughts on why this might be happening?</p>
  
  <p>Thanks!</p>