title: A good substitute for references/pointers in VBA?
body: <p>Can you recommend me a good substitute for reference or pointer types in VBA? I have been struggling for long with expressions like this:</p>
  
  <pre><code>dblMyArray( i * lngDimension0 + j * lngDimension1 + k * lngDimension2, l * lngDimension3 + m * lngDimension4 ) = dblMyArray( i * lngDimension0 + j * lngDimension1 + k * lngDimension2, l * lngDimension3 + m * lngDimension4 ) + 1
  </code></pre>
  
  <p>If I wanted to accumulate values in a multidimensional array in e.g. C++, I could write this:</p>
  
  <pre><code>double&amp; rElement = dblMyArray[ i * lngDimension0 + j * lngDimension1 + k * lngDimension2 ][ l * lngDimension3 + m * lngDimension4 ];
  rElement += 1;
  </code></pre>
  
  <p>or</p>
  
  <pre><code>double* pElement = &amp;dblMyArray[ i * lngDimension0 + j * lngDimension1 + k * lngDimension2 ][ l * lngDimension3 + m * lngDimension4 ];
  *pElement += 1;
  </code></pre>
  
  <p>I am looking for something like this.</p>
  
  <p>I don't want to repeat the element on the right side of the assignment and I don't want to call a function with ByRef arguments because that would make the maintenance of the code much more difficult.</p>
  
  <p>Any ideas?</p>