Continuation of prior question - "elegant" solution is generating at type mismatch on the match function of an array item within an array. The goal is to build an new array for a report extracting the necessary data from various existing arrays in various column locations. Also, the column that is being 'matched' is the first column in each of the arrays.
For x = 1 To RptRows
' (error is generated here)
ID_Fnd = Application.Match(ReportArray(x, 1), Application.Index(ProdArray, , 1), 0)
ReportArray(x, 7) = ProdArray(ID_Fnd, 2)
Watch is showing the following:
ReportArray(x,1) - variant/long
Application.Index(ProdArray, , 1) - variant/variant