Hi, I have a macro like this: When using the error, Type mismatch runtime error 13 pops up and points to the line: How to solve this problem? Thank you in advance for your help.

... enter the correct construction for: Code: VBScriptLog in, to see the code because this syntax refers to an object ' Selection ', not to the contents of the cell designated by this selection, and equal to TOTAL COST OF STATE * , e.g .: Code: VBScriptLog in, to see the code

I suggest you start by adding parentheses so that everything counts the way you want it, not the default. I know sometimes because of this (prioritization) there are all sorts of strange effects.

Better to add an attachment (runtime error 13 - different data types)

VBA Excel Macro: Type Mismatch Runtime Error 13 - Resolving Issues in Do Until Line

Reply | New topic

#1 16493046 24 May 2017 13:34

bursonik bursonik

Level 8

» |

Post #1
16493046 24 May 2017 13:34

Hi, I have a macro like this:

Code: VB.net
Log in, to see the code

When using the error, Type mismatch runtime error 13 pops up and points to the line:

Code: VB.net
Log in, to see the code

How to solve this problem?

Thank you in advance for your help.
ADVERTISEMENT
#2 16494690 25 May 2017 10:32

kinggustav kinggustav

Level 27

» | Helpful post? (0)

Post #2
16494690 25 May 2017 10:32

I suggest you start by adding parentheses so that everything counts the way you want it, not the default. I know sometimes because of this (prioritization) there are all sorts of strange effects.
ADVERTISEMENT
#3 16494727 25 May 2017 11:00

JRV JRV

VBA, Excel specialist

» | Helpful post? (+1)

Post #3
16494727 25 May 2017 11:00

Better to add an attachment (runtime error 13 - different data types)
ADVERTISEMENT
Helpful post

#4 16497118 26 May 2017 19:06

lanzul lanzul

Level 30

» | Helpful post? (+1)

Helpful post
Post #4
16497118 26 May 2017 19:06

bursonik wrote:
... When I use the error Type mismatch runtime error 13 appears and points to the line:

Code: VB.net
Log in, to see the code

How to solve this problem?

... enter the correct construction for:

Code: VBScript
Log in, to see the code

because this syntax refers to an object ' Selection ', not to the contents of the cell designated by this selection, and equal to " TOTAL COST OF STATE * ", e.g .:

Code: VBScript
Log in, to see the code
#5 16509818 03 Jun 2017 12:53

bursonik bursonik

Level 8

» | Topic author Helpful post? (+1)

Post #5
16509818 03 Jun 2017 12:53

thanks, it works!
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

Reply | New topic

Report a violation of the law

VBA Excel Macro: Type Mismatch Runtime Error 13 - Resolving Issues in Do Until Line

Didn't find an answer? Ask Artificial Intelligence