Argument ByRef in a Function when not using the return value.

[Ovier]

I have noticed an oddity when passing argument ByRef in a function when not using the return value. Take this example:

Please Login or Register  to view this content.

It print 15, as expected. Now remove the assignement when calling Triple:

Please Login or Register  to view this content.

To my surprise, it prints 5. Why this behavior? Is it documented somewhere? (I am on Excel 2016).

[TMS]

Why would it be anything else? You have commented out the call to the function so it has not changed.

[Ovier]

Sorry, I wrote too fast. The unexpected behavior happens when I do call the function, but not using the return value. I have corrected the initial post.

[rorya]

Because you put brackets round the argument. You only use those if you are using the return value (or you use the Call statement, or are specifically trying to evaluate an expression). So use:

Please Login or Register  to view this content.

not:

Please Login or Register  to view this content.