title: The default property for cells()
body: <p>I was under the impression <code>VBA</code> had default properties for all its objects. So that if I say <code>Cells(counter, x)</code> the default property attached will be <code>.value</code>. Additionally, I've always used <code>Cells(counter, x)</code> and <code>Cells(counter, x).value</code> interchangeably. However, when adding items to a collection via a for loop, I noticed if I did not include <code>.value</code> instead of storing the value, it stored the value as represented by the location in the worksheet. Such that if the location were deleted the reference in the collection would be lost. This brings me to two discoveries: 1) Collections can store non-static references, and 2) <code>Cells()</code> and other objects do not have default properties such as <code>.value</code>. </p>
  
  <p>If anyone can clarify, confirm, and enlighten, that would be excellent.</p>