Cell not refresh probably.....
Hi,
I'm running Office 2003 SP1.
I got a range of cells which refers to a function in a module. I'm getting
the following error when pointing to the exclaimation mark:
"A value used in the formula is of the wrong data type."
However, when I select one of this cell, and go into edit mode (I usually
press F2), then press Enter without modifying anything, the error
disappear, and I get a value from the function.
My problem is that I have a range(AE21:AI136) which pretty much used the
same formula, I can't expect user to go through each cell and fix it like the
way I had, so does anyone know how can I fix this?
Regards
Augustus
|