Custom function returns #NAME?

Question

I created the following function with this code to find the first numeric charactor in a string in a cell. Cell E3 contains the string to be checked. When I enter the formula =Pos_nonalpha(E3) it returns #NAME?. What am I doing wrong?

Thanks,

JCM

Function Pos_nonalpha(cell) As Long Dim i As Long For i = 1 To Len(cell) Dim Number Select Case Asc(Mid(cell, i, 1)) Case 0 To 64, 91 To 96, 123 To 191 Pos_nonalpha = i Exit Function End Select Next i Pos_nonalpha = 0End Function

Answer 1

Maybe you don't have macros enabled?

---

Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

Answer 2

Bill,

Sometimes the obvious is the answer. I did not realize that macros must be enabled for UDFs. Thanks all for your replies.

Much appreciated!

JCM

Answer 3

The presence of the Module name makes me suspect that you also have a range name Pos_nonalpha defined in the workbook. 

The presence of the workbook name suggests that you are attempting to call the function from a workbook other than the one in which it is defined.??

---

Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk