Hi

replace

Code:
.Range("a" & .Rows.Count).End(xlUp).Offset(1).Resize(n, UBound(k, 2)) = k
with

Code:
.Range("a" & .Rows.Count).End(xlUp).Offset(1).Resize(n, 10) = k