[Solved] Error 13 - Type Mismatch

[timefend]

Hello,
I'm trying to run this code, which works perfectly on one file, but is giving a type mismatch on another file I'm trying to use it on.

The issue happens on the following line:

index = Mid(FSMnumber, 3)

Any ideas? I can't figure out why it only works on certain sheets.
Thanks!
Tim

Please Login or Register  to view this content.

[dmcgov]

that is cause mid takes more arguments, you have:

Please Login or Register  to view this content.

when it should be something like:

Please Login or Register  to view this content.

Mid(string, start, [ length ])

let me know if that helps

[BrokenDome]

Mr. timefend,

Good morning sir!! Just wanted to inform you that you should put your code in a code block instead of a quote block as it would be much easier to read. You can use [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] in order to achieve this. Thank you!!

Dome

[Fluff13]

@dmcgov
You do not need to specify the length when using the VBA function Mid.

@timefend
What is the value of FSMnumber when you get the error?

Also as mentioned by BrokenDome, you need to edit you post to include code tags, rather than Quote tags

[timefend]

Thanks guys - changed the quote tags.

Fluff13 - The value of FSMnumber when I run the code is "X6", which contains a formula referencing another cell with a numerical value.

[Fluff13]

This

Please Login or Register  to view this content.

is trying to return the contents of FSMnumber starting at the third character.
But as it only contains X6, there is no third character, hence the error.

[timefend]

Thank you!

[Fluff13]

You're welcome & thanks for the feedback