| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set an arg list for my VBA functions | Excel Programming | |||
| Identify & List unique values from a list using functions/formulas | Excel Worksheet Functions | |||
| pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
| List of VBA Functions | Excel Programming | |||
| List all Functions | Excel Programming | |||
Threaded Mode
