Col of Concat-ed cell causes error when using Application.Index(arrS, i, 0) in diff Maro

I am using the Concatenation code I got (and modified into a function but I have not altered the code that concatinates) by @jindon, it works wonderfully.

The problem is that the column of concatenated cells throws a error in a different Macro that matches columns even though the concatinated column is not one of the matching columns of the matching macro.

If I delete the column of concatenated cells the matching Macro work fine.

The error ocrurs at this point in the matching macro

Please Login or Register  to view this content.

I am pretty sure the problem is

Please Login or Register  to view this content.

Is their a way to get the Concatenate code below to not produce this error when it encounters

Please Login or Register  to view this content.

Thank you

Please Login or Register  to view this content.

Turns out that some of the cells in the sheet were over the 254 char limit(figured out here by Paulyb)and this was causing the error 13 thrown by Application.Index(arrS, i, 0) in the maching function and had nothing to do with the ConCat code

The fix was to re-write the Matching function without using Application.Index(arrS, i, 0)