While copying worksheet in a workbook many times an error comes up stating that the application has caused an illegal operation and exits out of excel.
Each workshheet is data pertaining to a day.
This problem comes up randomly.I have no clue to it. To save rework I save my work before copying the worksheet.