OP wants to paste clipboard to ActiveCell, inserting rows to make room for however many cells are in clipboard.

Can't figure out a way to stop Excel from copying clipboard into every new cell in the inserted rows.

https://www.excelforum.com/showthread.php?t=1052424