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

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

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

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