Copy Method of Worksheet Class failed

[Baldev Kumar]

Hi

Following code is not working for me, getting error "run-time error '1004' Copy Method of Worksheet Class failed"

i am useing excel 365, workbooks in my downloads folder are in .xls format
i have saved the macro in personal workbook and running the macro in book1.xlsx

[Artik]

Try to run the code like this:

Please Login or Register  to view this content.

Artik