Where you defined the variable, define it wrong type.

E.g. Define the variable as Boolean, if actually it will be a string. Or
define it as Range if it is not going to a range at all.

Remove any On Error commands in the code.

So when the variable is first reached to assining a value, or to check
its value, you will get error 'Type Mismatch' or 'Object Variable or
With Block variable not set'.


Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!