I encountered a problem "run-time error '1004': copy method of worksheet class failed'. Does anybody know how to fix it? thanks a million. that part of code is as follow: sheets(i).select sheets(i).copy after:sheets(i)