Range("D2").PasteSpecial xlPasteAll

(or maybe xlPasteValues, if you already have formats in place that you want
to keep)

"BlueAngel" wrote:

I would like to insert the last thing copied into the clipboard starting at
cell D2. The copied item will have many rows and columns. Any idea what is
the best way to automate this with VBA?