ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   List workset fucntions (https://www.excelbanter.com/excel-programming/328027-list-workset-fucntions.html)

Jan Kronsell[_3_]

List workset fucntions
 
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



Dave Peterson[_5_]

List workset fucntions
 
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 wrote:

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


--

Dave Peterson

Jan Kronsell[_3_]

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

Jan

"Dave Peterson" skrev i en meddelelse
...
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 wrote:

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


--

Dave Peterson




Dave Peterson[_5_]

List workset fucntions
 
Copy from help and paste into excel?????

Jan Kronsell wrote:

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

Jan

"Dave Peterson" skrev i en meddelelse
...
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 wrote:

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


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 02:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com