<div>
Your array is too small. Try Dimming without a dimension and &nbsp;ReDim as needed.<br />

<pre><code class="code-10 nolinks" id="code-124151"><span>Dim arrFinalList()</span>
<span>m=0</span>
<span>n=0</span>
<span>f=0</span>
<span> </span>
<span>For m=0 To ubound(arrAllUsers,2)</span>
<span>  For n=0 To ubound(arrUserList) </span>
<span>      If arrAllUsers(1,m) = arrUserList(n) Then</span>
<span>         'We have a match. </span>
<span>          wscript.Echo &quot;Match: &quot; &amp; arrAllUsers(1,m)</span>
<span>         'Getting the error here... </span>
<span>          reDim Preserve  arrFinalList(f)        </span>
<span>          arrFinalList(f) = arrAllUsers(m)</span>
<span>           f=f+1</span>
<span>      End If</span>
<span>  Next</span>
<span>Next</span>
</code></pre>
</div>


<div>
Its giving me a 'subscript out of range on arrAllUsers' still
</div>


<div>
At what line is error?. &nbsp;Code seems correct. Are you sure arrAllUsers is dimensioned and filled properly. &nbsp;Are arrays dimensioned from 0 as opposed to 1? These could be a causes but can ony speculate as that code is not posted.
</div>


<div>
According to line 5 of your snippet, the array has two dimensions, so try<br />
<br />
arrFinalList(f) = arrAllUsers(1, m)<br />

</div>


<div>
It is a multidimensional array. &nbsp;I want to read all dimensions from arrAllUsers into a new array arrFinalList. &nbsp;Can this be done with a multidimensional array (it has 8 fields its pulling from a database).<br />
<br />
I Know I can copy the whole array over, but can I copy it line by line like in the example above?<br />

</div>


<div>
That got it. &nbsp;I wasn't using the bound,1 to create a dynamic list of the fields, so it was failing with an out of range subscript. &nbsp;<br />
<br />
I thought maybe there was a simple way to copy a single line from an array into a new array and automatically copy all the dimensions of that record, but it appears you must manually loop it as in the solution.<br />
<br />
Thanks to everyone for their help.<br />

</div>


<div>
That would be nice, but would have to work for both indices in the same way, and would get very complicated with more that the two.
</div>


<div>
<div class="content wysiwyg-content">
I have a script that need to compare two arrays (one single and one multidimensional) and output matches to a third multidimensional array. &nbsp;For some reason it just won't work for me - gives me a subscript out of range. &nbsp;Any ideas?<br />
<br />
<br />

<pre><code class="code-10 nolinks" id="code-124147"><span>m=0</span>
<span>n=0</span>
<span>f=0</span>
<span> </span>
<span>For m=0 To ubound(arrAllUsers,2)</span>
<span>  For n=0 To ubound(arrUserList) </span>
<span>      If arrAllUsers(1,m) = arrUserList(n) Then</span>
<span>         'We have a match. </span>
<span>          wscript.Echo &quot;Match: &quot; &amp; arrAllUsers(1,m)</span>
<span>         'Getting the error here...          </span>
<span>          arrFinalList(f) = arrAllUsers(m)</span>
<span>           f=f+1</span>
<span>      End If</span>
<span>  Next</span>
<span>Next</span>
</code></pre>
</div>
</div>


I have a script that need to compare two arrays (one single and one multidimensional) and output matches to a third multidimensional array.  For some reason it just won't work for me - gives me a subscript out of range.  Any ideas?



Compare Two Arrays, Output to third array

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.