Delete Sheets Crashes Excel - Repeatable Example attached - 2010

Hi,

After DAYS of head scratching - i have finally isolated a repeatable bug in my application. Strangely this combination of code has existed in my app for AGES and has not caused problems before, all of a sudden it has (i cannot pinpoint the change elsewhere in my app that has caused it to start happening all of a sudden)

I have managed to extract the code to a workbook and hopefully you will be able to repeat my experiment;

In Module 1 of the attached workbook is a simple macro to delete a worksheet
In Module 2 is a UDF

On Sheet "Copy2" there is a button that calls the delete macro - hit this button and excel will crash. It is the UDF that is doing it. If you comment out the UDF in Module 2 and repeat the experiment, the delete macro should run fine!!

Anyone know how i can prevent this from crashing Excel but still retain functionality of the UDF?

Cheers,
K

AttachmentExample for Crash.xlsm

For anyone else who comes across this thread - i made some changes to the function - took out the volatile statement and wrapped an IF around it - excel no longer crashes

Please Login or Register  to view this content.