Returning from a Function

Philosophaie · Apr 11th 2016

I keep getting a "type mismatch" error.
I have tried dim to double on all quantities and add "As Double" to the end of

Code

"Function apparent(Byval v As Double, Byval b As Double, Byval T As Double) As Double"

That gives the same "type mismatch" error.

Code

Sub First()
                    v=23
                    b=10
                    T=0.000567
                    app = apparent(v, b, T)
                    Xecl = app(0)'''Mismatch Error
                    Yecl = app(1)
                    Zecl = app(2)
End Sub
Function apparent(Byval v, Byval b, Byval T)
      X = 1.45
      Y = 0.78
      Z = 0.88
      apparent = Array(X,Y,Z)
End Function

Display More

skywriter · Apr 11th 2016

Re: Returning from a Function

How are you using this code that it gives you an error?

I run the second code you posted by stepping through Sub first line by line with all your hard coded values and I get no error.

You don't declare v, b or t in the code you posted, you just start using them and we don't know what Xec etc are or if you have declared them as a particular data type somewhere else, so it's hard to say.

I will tell you this, if I run your code as you have shown, since v,b and t are not declared as a particular data type, they are variants and with variants Excel waits to see what the values you assign are before it decides what to do with the value.

Therefore after running v=23, b=10 and T=0.000567, v is assigned by Excel as variant/integer, b is assigned as variant/integer and t is assigned as variant/double.

But since I don't know how you are using this and what's going on with these other undefined variables and what you are doing with the return values I can't say what the problem is.

Returning from a Function

Participate now!

Share