title: Range value not shown in locals window in Excel VBA
body: <p>I was wondering why there is no value property for range object listed in locals window. The value2 is listed there. At the same time I use the Range.Value in the code and it works ok:</p>
  
  <pre><code>Set Rng = Range("D6:D9")
  Set Rng2 = Range("B2:B5")
  Rng2.Value = Rng.Value
  </code></pre>
  
  <p>Does it mean that excel stores Range values by default in value2? I'm just curious how it works.</p>