<div>
And I believe you can also do:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42366076-1"><span>Dim rng1</span>
<span>rng1 = Union(Range(&quot;C8:C1000&quot;), Range(&quot;P8:P1000&quot;))</span>
</code></pre>
<hr />
»<b><i>bp</i></b>
</div>


<div>
Not worth an objection, but I would have preferred an equal distribution of the points.<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


<div>
<div class="content wysiwyg-content">
Hi,,<br />
<br />
I know how to define arrays and two dimensional, and place data in them, however how do I preload two dimensional arrays using ranges from different parts of the sheet, i.e C8:C1000 and P8:P1000<br />
<br />
Ta
</div>
</div>


Hi,,

I know how to define arrays and two dimensional, and place data in them, however how do I preload two dimensional arrays using ranges from different parts of the sheet, i.e C8:C1000 and P8:P1000

Ta

Load a two-dimensional array from two independent ranges

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.