paste selection??

[Douvid]

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

TKS guys

 

[Bob Phillips]

Douvid,

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

 

[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