reset function calls

Hi,

Apologize for the poorly chosen title.

I have made some functions and use a VBA run a solver routine. If I exit the solver routine using ctrl+break some cells will give a #Value! error. I Believe the problem is that I exit in the middle of a function call.

If I click the cells and press return the error disappears.

How do I reset these function cells using VBA? A simple Calculate doesn't do the trick.


regards,
Kbka

Its hard to imagine this kind of problem for me right now without an example file. Upload an example file and I will have a look