Last row in array

[Nagini]

Hello, I would like to use de application.Index function to extract a value from an array. The value es de last one in column 6. I Don't know how to write it. I have this code, which extracts the entire column.

y = Application.Index(resultArray, , 6)

Thanks

 

[micsza]

Please try this:

Application.Index(resultArray, ROWS(resultArray) , 6)

 

[Nagini]

It says error "13" and yellow line. ROWS(resultArray) = no coincidence<no coincidence=""></no>

 

[Norie]

If you want to get the last value in column 6 from a 2 dimensional array try this.

y = resultArray(UBound(resultArray,1), 6)