what is going here

  • Thread starter Thread starter Steven
  • Start date Start date
S

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
 
Back
Top