Copy and paste text from clipboard

Hello,
I have in "clipboard" a text which looks like this:
Text row1
Text row2
Text row3
..................and so on.....

I am trying to write a macro which would take each row (the number of rows varies every time) write them into a spreadsheet row by row , one beneath the other.
Could anybody advise, please?
Thank you

OK, I just realized that a simple "paste" would do it.