ive been reading up on doing a copy paste but bypassing the clipboard here's what i have but its not working. Is it possible to bypass clipboard if copy and pasting between different work books?
so basically copy from workbook "1" to workbook "2"
i get error 1004
"copy method of range class failed"
Sub diretcopy()
Workbooks.Open "M:\macro test\1.xlsx"
Workbooks.Open "M:\macro test\2.xlsx"
Workbooks("1").Activate
Sheets("Sheet1").Range("A1:H16").Copy Destination:=Workbooks("2.xlsx").Sheets("Sheet1").Range("A1:H16").Value
End Sub
Bookmarks