ByRef argument type mismatch / Passing array as a function argument

**pzling** · 10-28-2012, 08:07 PM

Hi

The intention is to get the function FD() to accept an integer and an array (of doubles) as input and return a double value. I've searched various forums and references and I *think* I have this part right. However when I compile, I run into a "ByRef argument type mismatch" when calling FD(). I just can't see how the argument types are mismatched, if anyone could help it'd be much appreciated.

Thanks
pz

Please Login or Register  to view this content.

**TMS** · 10-28-2012, 08:17 PM

As I understand it, you use ByVal to pass a variable to a function or subroutine when it is needed for the calculation but not changed. You use ByRef if you want to update the variable in the subroutine, that is, you pass its address, not its value.

You've said that the Function is to return a Variant, not a double. Then you Dim FD as Double in the Function. I would expect the function to be "As Double" and lose the Dim FD As Double.

Regards, TMS

**Norie** · 10-28-2012, 08:22 PM

You've declared inputData as a single variable of type Double, not an array.

Also, you've declared Close_ in InitialiseDataArray but you then try to refer to it in test.

You can't do that because it's out of scope.

Another problem is that you've declared a variable called FD in the function called FD.

I'm not sure what you are doing with that variable, do you even need it.

I re-arranged the code a bit but it stops at Highest(CalculationPeriod_) which I assume you haven't written yet.

Anyway here it is.

Please Login or Register  to view this content.

**pzling** · 10-28-2012, 09:12 PM

Thanks guys

Please see revised code following comments from above.

One thing that has now popped up is trying to deal with the scope issue of the array Close_. I tried to address it by declaring Close_ in sub test() and passing the array to sub InitialiseDataArray for initialisation, but then I get "Compile Error: Typemismatch: array or user-defined type expected" at

Please Login or Register  to view this content.

in sub test()?

Please Login or Register  to view this content.

**Norie** · 10-28-2012, 09:16 PM

Remove the brackets around Close_ when calling InitialiseArray.

Please Login or Register  to view this content.

**pzling** · 10-28-2012, 09:26 PM

Ah ha!

All good now. Thanks all for getting me across the line.

**Cutter** · 10-29-2012, 04:00 PM

@ pzling

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.