On Dec 20, 5:31 am, Joe M. wrote:
I added to the UDF so now it appears as follows but F9 and
the same attempts to recalculate still fail.

Is anything else not recalculating; or just this UDF?

Wild-ass guess: try executing the following macro, substituting the
proper worksheet name or looping for all worksheets:

Sub doit()
Worksheets("Sheet1").EnableCalculation = True
End Sub

If that works, be sure to save the workbook, after deleting the "doit"
macro, if you wish.

Setting EnableCalculation to False is really weird, IMHO. If I save
and reopen a workbook after setting EnableCalculation to False, any
RAND() references cease to calculate, but any newly added RAND()
references retain their volatile nature. It is as if setting
EnableCalculation to False affects the state of only used cells at the
time it is set. And it appears that the cell state is a "property" of
the cell, although I don't know what Property of the cell object might
be affected by it.

Note: To test the effectiveness of setting EnableCalculation to True,
then saving and reopening the workbook, it would be prudent to set
macro security to Very High or at least to Medium (and do not enable
macros). I think Very High would be better, on the off-chance (albeit
unlikely) that a "safe" macro is the cause of setting
EnableCalculation to False.

Again, this is a wild-ass guess with near-zero chance of being
effective, I think. But if nothing else explains your problem, this
might be worth a try.