Run-time Error '13' - Type mismatch

**elmowax** · 12-21-2014, 05:30 AM

I have about 40K+ lines of "raw data" that I need to analyze. I am only interested in the lines that contain the word "Degraded". I have a macro that searches all lines of raw data and extracts any line containing the word "Degraded" (this macro also unlocks and locks the worksheet). The macro was working fine in the past; however, I am now getting a "Run-time Error '13' Type Mismatch" when I run the macro. It seems to get hung up on the string
"If InStr(v, "Degraded.") > 0 Then"
This is probably because the word "Degraded" is not an integer.
Does anyone know a better way to do this, or other work-arounds.

The full macro is posted below:

Please Login or Register  to view this content.

**jindon** · 12-21-2014, 06:01 AM

You might have Error value in variable v.
try

Please Login or Register  to view this content.

However, it can be done with AutoFilter I guess....

**elmowax** · 12-21-2014, 03:46 PM

Thank you jindon. The macro seems to be working now. I'm not sure how your fix works, but It does. I'll have to study a little more about it. Thanks!!!!!!!!!!!!!!!

The new working macro is

Please Login or Register  to view this content.

**jindon** · 12-21-2014, 08:03 PM

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Run-time Error '13' - Type mismatch

LinkBack

Thread Tools

Rate This Thread

Display

Run-time Error '13' - Type mismatch

Re: Run-time Error '13' - Type mismatch

Re: Run-time Error '13' - Type mismatch

Re: Run-time Error '13' - Type mismatch

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Run-time error '13': Type mismatch

Run-Time Error '13: Type Mismatch

Run-time error '13' Type mismatch

Run Time Error '13'. Type Mismatch

Run time error: Type mismatch

Bookmarks

Bookmarks

Posting Permissions