Hi Brad,

If you want to force recalcualtion of function every time Excel
calculates, add the following line just after the custom function name:

Public Function blabla(...)
application.volatile '<<<<<< to be added

HTH

@+
FxM





Brad L. a écrit :

I created a custom function in VBA but when I use it in a cell it doesn't
recalculate unless I edit the cell. I have Excel set for automatic
calcualtion. It doesn't recalculate when I press F9. What am I doing
wrong?

Thanks