what is going here

[Steven]

hello

I have a grid of cells that evaluate their contents by
calling a user defined VBA functions.

This morning I returned to find that my work from Friday
was invalid about half the cells are populated with ####.

Bizarrely I can solve the problem by commenting out the
function eg
'doThis
'doForLoop
functionResult = 10

calculating the sheet,

then uncommenting code - it all works fine! Unfortunately
I do not think it is practical for day to day users!

Could it be I forgotten to initialise something?

Any explanations would be interesting to me.

Steven

 

[david]

try widening the cells to see what the error messages are


david