Hi,
my VBA script has run for many years with small changes, none recently, and only now I found Excel crashing when running certain operations. It always crashes with no error message when trying to copy a worksheet.
Code excerpt of all lines that contain the sheet:
It does not matter whether I just run the code or step through it. No other AddIn but my own is active. I have no HP printer. (These are three possible reasons for similar crashes I found in other threads.)
This is Excel 2013 on Windows 10. I tried on another PC with the same setup - no problem there. So there must be a difference between the setups, but I don't see it.
I'd appreciate any hint how to find the source of that issue ...
Thank you!
my VBA script has run for many years with small changes, none recently, and only now I found Excel crashing when running certain operations. It always crashes with no error message when trying to copy a worksheet.
Code excerpt of all lines that contain the sheet:
Code:
...
Public shtModel As Worksheet
...
Set shtModel = ActiveWorkbook.Sheets(strModel)
...
Application.CutCopyMode = False
shtModel.Copy before:=Sheets(1) '<- This is where Excel crashes
...It does not matter whether I just run the code or step through it. No other AddIn but my own is active. I have no HP printer. (These are three possible reasons for similar crashes I found in other threads.)
This is Excel 2013 on Windows 10. I tried on another PC with the same setup - no problem there. So there must be a difference between the setups, but I don't see it.
I'd appreciate any hint how to find the source of that issue ...
Thank you!
