I think you may have to pass the before and after parameters into the copy method. otherwise, the sheet will be copied to a new workbook.