I am trying to copy range A2:J2 down to the last row in column K using the below: i.e. if column K has 24 rows then
range A2:J24 would be complete with the data in A2:J2
my code is:
Dim lastrow As Long
lastrow = Cells(Rows.Count, 11).End(xlUp).Row...