I have spreadsheet that hinges around counting colored cells. I used a
user-defined CellColorIndex function to do this. It works great 90% of
the time. I use it in another spreadsheet that is dependent on macros
to move a bunch of information around. For some reason, about every
tenth time i run the macro, I get a value error in the cells where I
use the CellColorIndex function. To fix the error, all I have to do is
click on the offending cell and hit return. Without changing the
formula at all, the UDF works perfectly again. Has anyone else had
this problem? Does anyone know how to fix the problem?