Populate array from range - error

I am trying to populate a VBA array, based on values in a range of cells. Later, I will loop through the contents of the array and use the contents to complete a task. When I hardcode the array contents, everything works as intended. However, when I use the values in a range of cells, my range shape seems to change. It's almost as if I am adding an extra dimension to the range.
The first thing to note is that the both the LBound and UBound show 1 (I am using Option Base 1). There are 4 values, so I would expect the UBound to be 4. That may be one of the reasons that the loop fails.
I have attached a simplified sample file which includes both methods of populating the array.
Thank you in advance for your help.

By default, the variant that is assigned the cell values is a 2-D array: the first dimension is rows, the second is columns.

Please Login or Register  to view this content.

When you create an array from a range, surprisingly, it creates a two dimensional array where the second dimension is 1. Who knew? So, when you loop through the range, you can't just refer to, say, vArray(i), you need to refer to vArray(i, 1)

You're welcome.