paste selection??

D

Douvid

Hi All,
How do I copy 'selection' and then paste it in another
workbook in a specific place? ?

TKS guys
 
B

Bob Phillips

Douvid,

Try the macro recorder, and see what code you get. It should be all you
need.
 
L

losmac

The simpest way to find out how selection.Copy and Paste instructions works
is to record new macro.

Selection.Copy
Workbooks(2).Range("A2").PasteSpecial xlValues
 

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

Any way to change font in all styles being used in a document? 0
Paste options button disappears 0
Select Text to End of Footnote 9
Pasting a cell into bookmarked table from excel vba 1
How to make repeating drop-down lists? 2
How to paste this down? 3
Pages are changing pasted image... 0
Macro to select and delete levels of a document 2

Top