VBA runtime error 13 - Type Mismatch

[karan2807]

Hi Team ,

I need to get the whole row value from a 2d array but I am getting the runtime error 13 - Type Mismatch error.

I am using the following expression.

arr1 = Application.WorksheetFunction.Index(SparepartData, 1, 0)

sparepartdata = Array.



Please help

 

[karan2807]

Thanks for posting the code, unfortunately there is no way of testing it at this end so I cannot tell why you are getting the error.

Is this expression also depends on the number of columns ?? because when I am having 15 columns in this array I am getting this error but when I am reducing column to 3 this expression works fine.

 

[Fluff]

It may have something to do with the Null values in the array, but as I have never seen that & don't know for certain.

 

[karan2807]

Thanks for posting the code, unfortunately there is no way of testing it at this end so I cannot tell why you are getting the error.

Hey , One strange thing I have noticed that my array contains 15 column and in that case I am getting this error. If I am reducing columns to 3 the expression is working. any comments on this

 

[Fluff]

Please stop duplicating your posts, you have already said that & I have replied in post#12