Clipboard

B

BlueAngel

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

B Lynn B

Range("D2").PasteSpecial xlPasteAll

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to restore previous content of clipboard 3
Function to perform on closing an Excel Workbook 4
Getting info from the clipboard 1
Copy chart to clipboard 1
Managing Cut/Copy & Paste During Program Run 1
Copying cell text to clipboard (using Putinclipboard) 2
Find Empty Cell in Row 2
Validating clipboard data 1

Top