A good substitute for references/pointers in VBA?
<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>