List worksheetsheet functions
Thanks.
Jan
egun wrote:
You can also look up the RegisteredFunctions property in VBA Help.
This will list any non-built in functions (like those from DLLs or
add-ins like the Analysis TookPak). Their example code:
Sub List_Registered_Functions()
theArray = Application.RegisteredFunctions
If IsNull(theArray) Then
MsgBox "No registered functions"
Else
For i = LBound(theArray) To UBound(theArray)
For j = 1 To 3
Worksheets("Sheet1").Cells(i, j). _
Formula = theArray(i, j)
Next j
Next i
End If
'
End Sub
HTH,
Eric
|