BravesPiano5
03-20-2015, 09:29 AM
http://www.vbaexpress.com/kb/getarticle.php?kb_id=829#instr
Hello,
I am trying to combine all worksheets (sometimes 5-10 sheets) from all workbooks (40+) into one workbook with multiple sheets. The above code gets stuck here and I'm unable to figure out why:
WS.Copy After:=ThisWB.Sheets(ThisWB.Sheets.Count)
This is the run-time 1004 error I receive:
Method 'Copy' of object'_Worksheet' failed
Would you please help!? :crying:
Thanks!
BravesPiano5
Hello,
I am trying to combine all worksheets (sometimes 5-10 sheets) from all workbooks (40+) into one workbook with multiple sheets. The above code gets stuck here and I'm unable to figure out why:
WS.Copy After:=ThisWB.Sheets(ThisWB.Sheets.Count)
This is the run-time 1004 error I receive:
Method 'Copy' of object'_Worksheet' failed
Would you please help!? :crying:
Thanks!
BravesPiano5