Questions

User Defined Function in Excel

Tags:
+
0 Votes
Locked

User Defined Function in Excel

tkocher
I have attempted to put in a UDF in three different machines and get the same result. I get an error when I attempt to reference the UDF. I put in
Function AddUp(x,y)
AddUp = x + y
End Function

When I pick a cell in the worksheet and put in
=AddUp(5,2) I get an error #Name? I have unchecked the Require Variable Definition box so why won't it run?
  • +
    0 Votes
    neilb@uk

    I did paste in your UDF and it worked fine as I thought it would. The obvious question is did you save it into an xla add-in? Can you see the function name if you Shift-F3 and open category "User defined"?.

    Neil :)

  • +
    0 Votes
    neilb@uk

    I did paste in your UDF and it worked fine as I thought it would. The obvious question is did you save it into an xla add-in? Can you see the function name if you Shift-F3 and open category "User defined"?.

    Neil :)