You can use the following steps to help you tackle any Type mismatch error.
Run the code so that the error appears.
1. Click Debug on the error dialog.
2. Select View->Watch
3. Highlight the variable to the left of the equals and drag it into the Watch window.
4. Highlight everything to the...