**Question**:

I want to set multi values from Excel named range. I tested and got the failure: *"Array was not a one-dimensional array."*

**GoExcel**.**Open****(**"C:\Temp\Book1.xlsx", "Sheet1"**)**

**MultiValue**.**List****(**"myP"**)** **=** **GoExcel**.**NamedRangeValue****(**"MyRange"**)**

Is there anything missed?

**Solution**:

In Excel, the named range is a X*Y dimensions. X is the rows, Y is the column. While the parameter of multi-values in Inventor is one dimension. Even you defined the named range with only one column, it is not a correct usage to set it to the multi-values directly. You need to extract the values of the column we are interested in. e.g. the code below gets the values of the first column.

**GoExcel**.**Open****(**"C:\Temp\Book1.xlsx", "Sheet1"**)**

*' this is an array X*Y dimension*

rangeArray **=** **GoExcel**.**NamedRangeValue****(**"MyRange"**)**

*'create a list to get the values of the columns*

**Dim** oList **As** **ArrayList**

oList **=** **New** **ArrayList**

*'rangeArray.GetLength(0) means how many rows*

*'rangeArray.GetLength(1) means how many colmuns*

**Dim** oRowsCount

oRowsCount **=** rangeArray.GetLength**(0)**

**Dim** oColCount

oColCount **=** rangeArray.GetLength**(1)**

**Dim** oRowIndex **As** **Integer**

**Dim** oColIndex **As** **Integer**

**For** oRowIndex **=** **1** **To** oRowsCount

*' add value of each row one by one*

**For** oColIndex **=** **1** **To** oColCount

oList.Add**(**rangeArray**(**oRowIndex,oColIndex**))**

**Next**

**Next**

*'set it to the list parameter*

**MultiValue**.**List****(**"MyP"**)** **=** oList

**GoExcel**.**Close**