VBA Function in Excel

P

Pradeep

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.
 
D

Dave Peterson

Move the UDF code into a General module. Don't keep it in that worksheet
module.
 
Top