Run time error 1004 copy method workbooks failed

D

Danang

Joined
Sep 19, 2011
Messages
1
Reaction score
0
Dear All,

Kindly need your help about this matter :
1. I had excel macro below :
'copy worksheet
Windows("A.xls").Activate
Sheets(1).Select
Application.CutCopyMode = False
Sheets("me.").Copy Before:=Workbooks("B.xls"). _
Sheets(2)
2. It worked at the first time, but at the second time it can not work
3. When I try to manually copy from workbook A to B, it can not be done too
Please help me to solve this problem, fully desperate this time :(

Thanks for your assistance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 paste method of worksheet class failed 3
Run-time Error '1004' 1
Macro to copy value in field and insert it into filter 2
Run time error 1004: Method 'Sheets' of object'_Global' failed 0
Run time error 1004 Applicatin-defined or object-defined error (Copy from src to dest 1
VBA runtime error 1004; Method of 'open' of object 'workbooks' failed 1
macro required.. 1
Cell Reference 1

Top