Byref argument type mismatch

**ref** · 02-16-2012, 04:54 AM

I get "Byref argument type mismatch" error in the following code. Don't know how to fix it.

Please Login or Register  to view this content.

I get the error in the EF(i) format.

Also, changing the Emm and Ef declaration as Double

Please Login or Register  to view this content.

i get "Type mismatch: array or user-defined type expected" error.

**Andy Pope** · 02-16-2012, 05:57 AM

you declare the array EF as variant and then try to pass it to the function Emissions which is expecting a double.
So convert the argument when passing it.

Please Login or Register  to view this content.

**ref** · 02-16-2012, 06:01 AM

Originally Posted by Andy Pope

you declare the array EF as variant and then try to pass it to the function Emissions which is expecting a double.
So convert the argument when passing it.

Please Login or Register  to view this content.

Thx Andy, it worked.

**AndyPS** · 02-16-2012, 06:17 AM

CDbl trys to convert other data types to a double but some values will fail. For example "1.234" and "1,234" will convert but "1x234" will fail with error code 13, Type mismatch.
VBA does a lot of automatic type convertions (e.g. long to double) making the right-hand side of the equation the type needed for the left-hand side. There are 11 explicit type conversion functions listed in Excel help.
Kind regards.