Yes [aK = Application.WorksheetFunction.Transpose(rK.Value) ]
I have over 7000 rows of data in Col G and over 400,000 rows of data in col K.
when I run it i get the run time error 13 mismatch at that line of code.
meaing when I debug it highlights that line of code.