vba to copy from workbook to another

[p4nny]

Hi

I would like to copy a range of data from one workbook to another using vba.

Both workbooks are already open from a previous process.

Please could you help?

Many thanks

 

[XLfriend777]

Hi p4nny - The code below may help you get started.

Sub p4nny_copy_to_new()
    Windows("Book1").Activate
    Range("A1:A10").Select
    Selection.Copy
    Windows("Book2").Activate
    Cells(1, 1).Select
    ActiveSheet.Paste
End Sub