Hello,
This behavior is a bit odd...
If I select the individual Cells A1 and A10 in Workbook 1 and try to paste into a new workbook it will paste the entire A1:A10 range in the new workbook.
I can paste within Workbook 1 and it will paste the individual cells into a column, but any paste attempt outside of workbook 1 pastes the entire range.
Is there any way to fix this?