Run-time error '13': Type mismatch

I apologize. I am not able to upload the sample file, post a link, or post an image, and can't figure out how to delete this post.

I am a novice at creating macros and this one is not mine. I need some help figuring out what is casing the type mismatch error. Run the StartMacro script, uncheck the bottom box, then click the Run button to reproduce the error. Thanks so much for your help!

EXCEL_WDFNt9OMq4.png

Link to file: https://tinyurl.com/3ww294vd Moderator's note: I tried to attach this as a zip and also xlsb and the board gave me an error on both.

New members cannot post live links. Members cannot delete posts.

Anyone can attach an image or a file.

The yellow banner at the top of the page explains how to attach a file. If you still have trouble after trying that then PM me and I'll help.

To attach an image, first click Go Advanced under your edit box. Then click in the text to set the cursor to where you want the image to appear, then press the image icon and attach your image.

I will take a look at the file at the link you sent me, but meantime you should be typing all your variables. anArray and searchStr are untyped, and from the snippet here we can't see what data is being passed in through those arguments.

When you get this error, open the Immediate window and type

?typename(anArray(i, 1))

and then

?typename(searchStr)

If the results to either one of these is not String, that is what your problem is. You declared each of these as Variant so the caller can pass in a value of any data type. That is not a good programming practice.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...match.1243615/)

Still looking for the steps to reproduce the error in your file.

Originally Posted by oarsout

Thank you for your response, Ali.

I have responded to your PM complaining about being "scolded" for cross-posting. In my response I have pointed out that the message above merely explains the rule we have and why it is in place. It is polite and to the point, NOT unfriendly as you suggest, and is a stock message used by the moderation team here.

We have rules here that apply to ALL members and the moderation team is required to deal with anyone who fails to follow them. The requirement is that we deal with the issue in the thread in question, not privately.

I am sorry that you feel offended, but you have not been scolded by any stretch of the imagination, and I am merely doing my job (and doing it politely).

Please do review the forum rules before posting here again so that neither I nor anyone else on the moderation team has to remind you of them in future.

Thank you.