| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling a public function from a worksheet
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calling a Public Function | Excel Programming | |||
| Calling Public Variables between diff Modules | Excel Programming | |||
| Calling? Invoke Public Function | Excel Programming | |||
| calling VBA function within a worksheet | Excel Programming | |||
| Calling a Public Subroutine in a Different Workbook | Excel Programming | |||
Threaded Mode
