VBA Function in Excel

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

 

[Dave Peterson]

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

 

[Pradeep]

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

Thanks it worked