CODEWITHSUNDEEP
vbaexcel
Agent96
Agent96

Reputation: 475

VBA Type mismatch Error - inconsistency

Okay, I'm so confused right now, I have written some VBA which is a plugin in Excel. There is a line which reads:

obsValue = CDbl(dataSplit(1))

The value of dataSplit(1) is the String 21440.5395043259

This line of code works okay...for me. For another user of my code they get

Run time error '13:' Type mismatch.

They click on debug, it takes them to this line of code, and they hover their cursor over the dataSplit varaible, and it does indeed read the same value as above.

enter image description here

We are both using Excel 2010.

How can this be?

Upvotes: 2

Views: 1416

Answers (1)

ThunderFrame
ThunderFrame

Reputation: 9461

The language settings of Excel will determine what the decimal separator is. It seems likely that for your user, their language settings are different, and so the "." is probably treated as a thousands separator. The CDbl function is locale aware, so it "sees" numeric strings according to the regional settings of the current user.

You could try using the Val function, which will always treat the period as a decimal separator.

obsValue = Val(dataSplit(1))

Upvotes: 3

Related Questions