title: How do I assign an one-dimensional range to a two-dimensional array in VBA
body: <p>Let's say I have a a range variable <code>aRange = range("A1:D1")</code>, and a dynamic array <code>Dim result() As Variant</code>, <code>redim result(1 to 2, 1 to 5)</code>, what's the best way to copy <code>aRange</code> to the first row of array <code>result</code>, from element (1, 2) to element (1, 5)? Assume result(1, 1) is temporarily empty. Basically, I am asking assigning a range object's value to an empty array using slicing.</p>