I ran it and i got the run time error messge again I did the Debug and it highlited the
[aK = Application.WorksheetFunction.Transpose(rK.Value)]
Run-time error'13':
type mismatch
I guess th transpose has a limit of over 65000 rows, can this be overcome? it worked without transpose on the 3 matching how can we get it to work with the 4 matches and 5 matches?
Ichecked all my data and nothng is wrong with it but everytime the transpose ised i get this error, im stuck and baffled.
can this be fixed please?
Reply With Quote