DLL function crash excel when called from worksheet

[gibus]

Hi Everyone,

I have an issue with excel at the minute I can't for the life of me figure out.
Using Excel 2016 32 bit:

Code:

Please Login or Register  to view this content.

As expected this will print the answer of 60 to the immediate window.
However...

When the divide function (or a function with the divide function) is called from a cell in a worksheet excel crashes. No errors given it's just "stopped working".
I suspect this doesn't have anything to do with the DLL function itself. Maybe some security issue with excel?

Any help is appreciated.

Thanks,

Edit: I still didn't solve why it's crashing. But I ended up recompiling the dll in gFortran instead and rewriting the VBA code and now it works.