Copy a Range of Excel to an Array using VB.net

[ubifsj]

Hello

I'm trying to copy a range of cells from an excelsheet to an array in Vb.net. But the last line doesn't seem to be working! Any idea how I can fix the problem?

Imports MyExcel = Microsoft.Office.Interop.Excel
Dim MyArray (3) As String

MyArray = MyWorksheet.Range("D2", "D4").Value


I can make it work for with a For Loop but not using the range.value

Thanks

 

[WarPigl3t]

Dim myArray(Range("D2").Value, Range("D4").Value) As Variant

 

[ubifsj]

It Doesn't work. Variant is no longer supported. Instead Object to be used. Also Range(("D2").value) could be a string so it's not the solution!

 

[WarPigl3t]

No longer supported? Is that an Excel 2013 thing? I'm using 2010

 

[ubifsj]

No it's not an excel issue. It's not supported in newer version of VB.net using Visual Studio. The message says: Variant is not a supported version, Use the Object Type instead.
I found the solution. I had to declare the MyArray as a two dimensional array.
Private MyArray(,) As Object = Nothing