Find_Cells_In_Column, Subscript out of range Error

I am getting a "Subscript out of range" Error and cannot identify the correct solution. What am I missing? Please help.

Thank you

OX

Please Login or Register  to view this content.

Hello oxv,

Welcome to the Forum!

A range object will always return a 2-D array of values even if the range is only a single row or column. You have to have 2 subscripts to access any element in the variant array "MyArr".

If you want to walk through the rows of "Parts Array" and it is a single column then you would use MyArr(i, 1), where 1 is the left most column of range. If it is a single row then you would use MyArr(1, i) where 1 is the top most most row of the range.

Hello OX,

The devil is in the details. Glad I could help.