[SOLVED] clipboard bypass not working

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"

Please Login or Register  to view this content.

Remove .Value at the end.

Please Login or Register  to view this content.