I wrote a macro in Excel 2000. Part of it checks a
particular cell and reads the value. This cell should be
a number (and is defined as such). When a client trys to
use my macro on Excel 97 he gets a run time error, type
mismatch. When he opens visual basic it points to the
line where I check the value of this cell to see if it
already appear in a database keep in a separate sheet. I
am not able to recreate this on my computer. Also I am
using protected and unprotected cell on is sheet too (I am
not sure if this would be related). The run-time error
appears when he tries to execute my macro. Do you have
any advice?