Run-Time error 13 type mismatch

**clundeen** · 11-17-2013, 03:21 PM

I am having trouble with a macro - it runs in one spread sheet but not another - is it the macro or the worksheet? Debug points to line "for each cell in range"

Please Login or Register  to view this content.

**Norie** · 11-17-2013, 03:50 PM

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

**clundeen** · 11-17-2013, 03:58 PM

here you go

**clundeen** · 11-17-2013, 03:59 PM

ctrl+shift+u to unlock hidden sheets

**Norie** · 11-17-2013, 04:03 PM

The error isn't on the For Each line it's on this line.

Please Login or Register  to view this content.

This part of the line returns a string and when you try to add the numeric value 14 to it you get the type mismatch error.

Please Login or Register  to view this content.

**clundeen** · 11-17-2013, 04:23 PM

the +14 worked before - used to jump 14 cells down on schedule tablet sheet

Run-Time error 13 type mismatch - HELP

LinkBack

Thread Tools

Rate This Thread

Display

Run-Time error 13 type mismatch - HELP

Re: Run-Time error 13 type mismatch - HELP

Re: Run-Time error 13 type mismatch - HELP

Re: Run-Time error 13 type mismatch - HELP

Re: Run-Time error 13 type mismatch - HELP

Re: Run-Time error 13 type mismatch - HELP

Thread Information

Users Browsing this Thread

Similar Threads

Run Time error 13 : Type Mismatch

[SOLVED] Run-time error 13 type mismatch

Run Time Error 13 Type Mismatch

Run-time error '13':Type mismatch

Bookmarks

Bookmarks

Posting Permissions