Copy , transfer range from w/book AAA to W/book BBB .

[Sunline]

Hello all ,
I have this macro which can only copy and transfer data one col at a time .

Im wanting to copy from workbook AAA range A2:BF434326 to workbook BBB destination A2 .
No idea how to alter this macro below .

Sub Test()
    Workbooks("AAA.xlsm").Worksheets("Sheet1").Columns(1).Copy Workbooks("BBB.xlsm").Worksheets("Sheet1").Range("A1")
End Sub

Many thanks .

 

[Anthony47]

Try this:

Sub Test()
    Workbooks("AAA.xlsm").Worksheets("Sheet1").range("A2:BF434326").Copy Workbooks("BBB.xlsm").Worksheets("Sheet1").Range("A2")
End Sub

 

[Sunline]

Great thanks Anthony47 , its perfect .

Thanks again .