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,

--
jwm