Please can someone help, I have gone through numerous websites trying to find an answer to this problem.
I have a workbook that contains many different macros that are all working well. But I have one worksheet that is causing me a great deal of issues. Basically all it is doing is selecting data, copying and pasting to another worksheet. The macro does what it is supoosed to do but when it exits the su, excel crashes, I get no de-bug or help on the problem from excel.
So that all my data does get lost after the crash I have included a save as so at least when I opened it back up all the moved data is where it should be.
To try and de-bug this problem I have disbaled parts of the code to see if there is a particular section of code causing the problem, but no I have found nothing. I have ended up disabling all the code apart from the save as and the double click that activates the macro and excel still crashes. I have similar code to this in other parts of the workbook and it seems to work fine. I am very confused can anyone help or suggest anything I can try?
Thanks for looking
Bookmarks