Excel Crash with User Defined Function

Add-in Express™ Support Service
That's what is more important than anything else

Excel Crash with User Defined Function
Excel Crash with User Defined Function 

Posts: 29
Joined: 2015-05-12
I am experiencing an "Excel crash" issue with a UDF in my XLL module.
The first parameter of my UDF takes an Excel range so that the UDF is only calculated if a cell in that range is affected. If I modify a single cell in the range, the UDF works fine and does not crash. However, if I try to copy and paste to multiple cells at the same time, a crash will typically occur on the second or third time.

Is there anything obvious that would cause this crash (without you reviewing my detailed code)? If not, is it possible to prevent my UDF from running if multiple cells are changed at one? In other words, the UDF should only run if a single cell was changed.

Posted 14 Jun, 2021 11:25:38 Top
Andrei Smolin

Add-in Express team

Posts: 18219
Joined: 2006-05-11
Hello Matt,

I don't understand the test scenario. Consider creating a simplified version of your code and sending it to the support email address; find it in {Add-in Express installation folder}\readme.txt; please make sure your email contains a link to this topic.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 14 Jun, 2021 11:57:49 Top