recalculation not recalculating some cells containing user functio

[velvetlady]

I have the following situation:
1) workbook contains User Function macros in some cells.
2) #VALUE appears in some of the cells
3) if i select the cell and use "F2" to edit then the value is correctly
calculated
4) pressing "F9" will not cause the cells to recalculate nor will
5) running a macro containing the following
Application.CalculateFullRebuild
what must i do to force the cells to recalculate without having to
physically perform
#3 above on each cell.

thanks,

 

[Jim Thomlinson]

application.volatile

at the start of the UDF will make the function volatile and will cause it to
recalc with every calculation. The good new is it will racalc. The bad new is
that it will always recalc which has smoe overhead....

 

[Dave Peterson]

Make sure you pass all the ranges that your UDF uses to the function.

For more, er, better responses, you should post your code.