ExcelBanter - Clipboard

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Clipboard (https://www.excelbanter.com/excel-programming/441740-clipboard.html)

BlueAngel

Clipboard

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?

B Lynn B

Clipboard

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?

All times are GMT +1. The time now is 02:25 AM.