Jenna has attended:
Excel VBA Intro Intermediate course
VBA
What does run-time error 13 mean?
RE: VBA
Hi Jenna
Run-time error 13 is a Type mismatch error. This means that the variable isn't of the correct type.
A variable that requires an integer value can't accept a string value unless the whole string can be recognized as an integer (eg "125").
To overcome this problem you should always make assignments between compatible data types. For example:
An Integer can always be assigned to a Long, a Single can always be assigned to a Double, and any type (except a user-defined type) can be assigned to a Variant.
Hope this helps
Carlos