Nametest is a worksheet. Nametest will be the sheet for whatever document is in question.
But select the sheet is no longer my problem, the code is working for that. I'm trying to get the data to be copied to nametest, to the next available row between B20 & N29.
testRow = Nametest.Range("B20:N29").End(xlUp).Offset(1, 0)
tried doing ti this way but it just copies the data to the first row of Nametest sheet, and not within the specified range