I want to read all values from an Excel Sheet into an Array through a function. But when using the "returned" array, i am getting "Type mismtach" error. Here is the code
Dim sValues( )
ReDim preserve sValues (10)
Here ReadExcelFile reads all the values from File and returns an array. And i want to assign that array to sValues(which is an Array) but i got "type mismatch" error. So can you tell me how should i use the returned array here.