List workset fucntions

[Jan Kronsell]

Is there a way to list all worksheet functions in Excel, using VBA?

I've tried something like

For Each W in WorksheetFunctions

and something like that.


Jan

 

[Paul B]

Jan, I don't know of a way to do it in excel, but if you want a list of them
have a look at these sites

http://www2.odn.ne.jp/excel/functioninenglish.html

http://office.microsoft.com/en-us/assistance/HP052042111033.aspx


Excel Function Dictionary -- by Peter Noneley, is a workbook with an
explanation and example of Excel functions.
Peter's site was hijacked by a porn site and I do not have his new address
but Ron de Bruin has a copy of the file for download at his web site,
http://www.rondebruin.nl/id.htm , it's at the bottom of the page, hope that
will help you


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Jan Kronsell]

Thank you. I knew the list, just wondered if I could make one myself. I
suppose the functions are in a collection, so I thought it should be
possible to list the members of the collection.

Jan

 

[Dave Peterson]

I went into Excel's help and searched for the worksheet functions. Then I
copied the short descriptions (by category) to an MSWord document.

Not quite the same thing, but not too difficult either.

 

[Jan Kronsell]

My problem is that I just need the names of all the funcctions, preferably
listed in a column in a spreadsheet.

Jan

 

[Dave Peterson]

Copy from help and paste into excel?????

My problem is that I just need the names of all the funcctions, preferably
listed in a column in a spreadsheet.

Jan