You have Pulic Function!

try...

Public Function

--

Regards,
Nigel




"JWirt" wrote in message
...
When I call this public function from a worksheet cell (e.g.,
=Nspaces(7)),
the result is #NAME?

Pulic Function Nspaces(NumSp As Integer)
Dim Nspaces1 As String
Nspaces1 = ""
While Len(Nspaces) < NumSp
Nspaces1 = Nspaces1 & " "
Wend
Nspaces = Nspaces1
End Function

Why?

I created this function in a separate module in Personal.xls.

Thank you.

John