id="info"

Question

Locked

User Defined Function in Excel

By 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?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

I can't see a problem

by neilb@uk In reply to User Defined Function in ...

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 :)

Back to Software Forum
2 total posts (Page 1 of 1)  

Software Forums