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
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Pasting from the clipboard 3
Managing Cut/Copy & Paste During Program Run 1
Copy value of textbox to clipboard for use in another application 5
Space at end of multi page list to accommodate new entries 1
Copy/Paste (Clipboard) Issues 1
Need Help with a VBA subroutine 0

Top