Assigning worksheet range to an array
<p>I am trying to assign ranges in worksheets to array variables, and it is not working out so far. Not an expert on the subject in VB, any help is appreciated. The ranges I have typed in are definite, however the array declaration for row and column size is just a guess thus far. Thanks!</p>

<pre><code>Dim runningavg(1 To 10000, 1 To 76), chartdata(1 To 598, 1 To 121) As Long

runningavg = Worksheets("Running Avg Log").Range("A4:BX10004")
chartdata = Worksheets("Chart Data").Range("B6:DR604")
</code></pre>