Excel 2003 my user defined function does not

February 4, 2011 at 12:01:49
Specs: Windows 7
Hi ,

Here's my fiunction (inserted in Module1):

Function Add(number1, number2)
Add = number1 + number2
End Function

Then going back to Excel worksheet to enter my formula in A3 cell :

=Add(A1, A2)

where A1 = 2 and A2 = 3 (formula should return 5 in cell A3) .
Everything seems ok until I type the second cell address "A2".

A pop up is then displayed saying :"The formula you typed contains an error....."

If I type a semi-colon instead of a comma, I get the #NAME? error in A3 cell.

If I use the insert function icon to enter my formula, I'm offered to select it in the "Select a function" list of available functions . The name of the function appears in the following style:


When I click ok a pop up box tells me : "This function takes no arguments." When I click ok on that one the formula appears in the formula bar with parenthesis but without arguments and the #NAME? eroor is displayed in A# cell.

See More: Excel 2003 my user defined function does not

February 5, 2011 at 15:35:36
Your UDF works just fine for me.

The only difference I see is that if I use Insert...Function and then choose User Defined it simply shows Add.

If I select it, the wizard lets me select 2 cells and then "adds" them.

In other words, it works both when either manually entered and via the Insert Function wizard.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question