What am I missing when I want to use VBA within Excel 2010?

Question

I have a possibly boring question for you guys. I try to get VBA for Excel running on a borrowed Windows laptop but I don't succeed in doing so.

For example, a simple function like:

Function addtwo(a,b)
     addtwo = a + b 
End Function

... does not work properly. All functions return #VALUE!.

I have set the macro settings such that all macro's should be enabled.

What is going wrong? I am totally lost....

Thanks in advance.

chris neilsen · Accepted Answer · 2013-12-28 00:02:32Z

1

Your function does work as a UDF (called from a formula in a cell). And it is being evaluated, so your security settings are fine (it it wern't you would get #NAME? and not #VALUE!)

So, the function itself is returning the error. One way this can happen is if you pass it one numeric and one string parameter.

answered Dec 28, 2013 at 0:02

chris neilsen

53.3k10 gold badges91 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

What am I missing when I want to use VBA within Excel 2010?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related