help on UDF code

D

Dave F

I have the following code to create a UDF to calculate reciprocals:

Function Reciprocal(a)
Reciprocal(a) = (1 / a)
End Function

The code is in a module.

I get #VALUE! errors when I try to run it. So I think this means that Excel
recognizes the UDF (otherwise it would return a #NAME error, right?)

So what's the problem here?
 
G

Gary''s Student

Avoid the appearance of recursion:

Function Reciprocal(a)
Reciprocal = (1 / a)
End Function
 
Top