I have written a function in VBA. When I use that function in Excel it
gives me #Name!, which i think probably means that it could not find
the function. The function is defined in the same sheet.
kindly advice.
Move the UDF code into a General module. Don't keep it in that worksheet
module.
> I have written a function in VBA. When I use that function in Excel it
> gives me #Name!, which i think probably means that it could not find
> the function. The function is defined in the same sheet.
>
> kindly advice.

Signature
Dave Peterson
Pradeep - 19 Jun 2007 13:23 GMT
> Move the UDF code into a General module. Don't keep it in that worksheet
> module.
[quoted text clipped - 8 lines]
>
> Dave Peterson
Thanks it worked