R
REM
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
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