In a current workbook. Want to copy a range to another workbook. Error message: Compile error: .Copy Method or member not found?
Sub Select_current_region()
Range("A1:I132").Select
Selection.Copy Destination:=Workbooks("AB Europe Gmbh - BS Rec Sep.xlsm").Worksheets("TB Sep").Range("A1")
End Sub
Sub Select_current_region()
Range("A1:I132").Select
Selection.Copy Destination:=Workbooks("AB Europe Gmbh - BS Rec Sep.xlsm").Worksheets("TB Sep").Range("A1")
End Sub