Making a Multi-line Array in Excel VBA?
<p>I'm trying to make a multi-line array variable, but it's not working for some reason and I can't work out what I am doing wrong...</p>

<p>The following array works correctly:</p>

<pre><code>aInter = Array("Item 1", "Item 2", "Item 3", "Item 4", "Item 5")
</code></pre>

<p>However, when I try and make a multi-line array using the line continuation <code>&amp; _</code> it doesn't let me</p>

<p>I've tried various ways:</p>

<pre><code>aInter = Array("Item 1", "Item 2", "Item 3" &amp; _
"Item 4", "Item 5")

aInter = Array("Item 1", "Item 2", "Item 3", ) &amp; _
("Item 4", "Item 5")

aInter = Array("Item 1", "Item 2", "Item 3") &amp; _
("Item 4", "Item 5")
</code></pre>

<p>What's the correct way of doing it?</p>