Calling a public function from a worksheet
try:
=personal.xls!nspaces(7)
(and fix the public typo)
or use:
=rept(" ",7)
JWirt wrote:
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
--
Dave Peterson
|