User Defined Function not recalculating
I'd be grateful if anyone can help me with a User Defined Function problem, a simple example of which is shown in the attached file.
The problem is that my function ("cof_pricer") works perfectly well, but when the data (C3:C5) is changed, the function doesn't automatically recalculate In each case, I have to go into the respective cells (E3:E5), 'F2' to edit the cell, press enter, & the correct calculation takes place.
This is obviously less than satisfactory, and I need to get the function to recalculate automatically every time the data changes. I have included a second (very simple function) called Two_mth_Ave (d4:d5), which DOES recalculate on changing the data, to illustrate that it isn't Excel that's at fault!
There is presumably something in my VBA coding that needs tweaking.
Does anyone have any ideas?