Hi,
I have a VBA code that creashes my excel every time I run it. the funny thing is that it works on 2 different PC well.
It involves copying information from an array placed in a class, run some data verification on it and save it in different class.
As hard as try I cannot find any code error (the code is rather long and complex) - but as I said it works well on other computers, so there probably is no major issue.
I am also not able to find the exact spot where it crashes. if I step trough the code it works, but once I run it crashes excel.
The original problem was with Excel 2010 x64 win 7, I have also tested it with excel 2013 x64 and on both excels under virtual Win 8.
No matter the configuration the excel would crash on 1 machine and work on others.
I have also tested exporting all modules and importing them to new workbook. running the code would freeze excel again :/
My CPU is Intel C2D P8700
any suggestions on how to fix this or where to look for more help?
thanks
I have a VBA code that creashes my excel every time I run it. the funny thing is that it works on 2 different PC well.
It involves copying information from an array placed in a class, run some data verification on it and save it in different class.
As hard as try I cannot find any code error (the code is rather long and complex) - but as I said it works well on other computers, so there probably is no major issue.
I am also not able to find the exact spot where it crashes. if I step trough the code it works, but once I run it crashes excel.
The original problem was with Excel 2010 x64 win 7, I have also tested it with excel 2013 x64 and on both excels under virtual Win 8.
No matter the configuration the excel would crash on 1 machine and work on others.
I have also tested exporting all modules and importing them to new workbook. running the code would freeze excel again :/
My CPU is Intel C2D P8700
any suggestions on how to fix this or where to look for more help?
thanks