Hello,
Trying to assign code to comm. button on User form to copy lets say:

(sheet1, rangeB2:B21) to (sheet2, first blank row rangeB2:B21) and paste it as text value
one more question: what to be aware in case of sheets format (merged cells, hidden rows...)