BartH
New Member
- Joined
- Jul 4, 2006
- Messages
- 14
Hi,
We are able to list for instance all sheets in a workbook:
How can I list all worksheetfunctions?
We are able to list for instance all sheets in a workbook:
VBA Code:
Sub getSheetsOfWorkbook()
Dim sh As Worksheet
Dim i As Integer
ActiveWorkbook.Sheets.Add
For Each sh In ActiveWorkbook.Sheets
i = i + 1
ActiveSheet.Cells(i, 1) = sh.name
Next
End Sub
How can I list all worksheetfunctions?
Rich (BB code):
Sub getEachFunction()
Dim f As WorksheetFunction
Dim i As Integer
ActiveWorkbook.Sheets.Add
For Each f In Application.?
i = i + 1
ActiveSheet.Cells(i, 1) = f.name
Next
End Sub
Grtz BartH