Hi,
I have a complex sheet with long formulae and functions. This
normally works well but occasionally the cells with formulae or
functions display only #VALUE!

I have Application.Volatile at the start of each function and a full
recalculation does not cure the problem.

Only editing each cell and pressing enter gives the correct value.

I could use a workaround but would appreciate any suggestions of why
this should be happening so I can correct it.
Many thanks,
Rod