with Workbooks("Firstbook.xls").Sheets("Sheet1")
.Range("A1:M1000").copy Destination:= _
Workbooks("Secondbook.xls").Sheets("Sheet1").Range ("A1")

"RobcPettit" wrote:

Hi Id like to copy some data from one open workbook to another open
workbook using vba. Date in first workbook is in sheet1 a1:m1000. Id
like to copy this to sheet1 in the second workbook. Any ideas please
Regards Robert