Is there a macro that can be used to list all of the VBA worksheet functions
in column A of a workbook? Thanks.

goto VBA help..
search on WORKSHEETFUNCTION

select Using Microsoft Excel WorksheetFunctiond in Visula Basic
click the hyperlink to "List of Worksheetfunctions etc.)

select m all
press ctrl C
goto Excel..
press ctrl V
select Edit/Clear/Clear Formats
sort ascending.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam

?B?SkZN?= wrote in message
:

Is there a macro that can be used to list all of the VBA worksheet
functions in column A of a workbook? Thanks.

JFM wrote:
Is there a macro that can be used to list all of the VBA worksheet functions
in column A of a workbook? Thanks.
I know what Worksheet functions are. What do you mean by *VBA*
worksheet functions?

Alan Beban

VBA will not handle every worksheet function. Just like there are macros
that will list the name of every font that can be used, I'm wondering if
there is a macro that will extract a list of every worksheet function that
can be used with VBA and then copy that list to a worksheet range.

"Alan Beban" wrote:

JFM wrote:
Is there a macro that can be used to list all of the VBA worksheet functions
in column A of a workbook? Thanks.
I know what Worksheet functions are. What do you mean by *VBA*
worksheet functions?

Alan Beban

Thanks.

"keepITcool" wrote:

goto VBA help..
search on WORKSHEETFUNCTION

select Using Microsoft Excel WorksheetFunctiond in Visula Basic
click the hyperlink to "List of Worksheetfunctions etc.)

select m all
press ctrl C
goto Excel..
press ctrl V
select Edit/Clear/Clear Formats
sort ascending.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam

?B?SkZN?= wrote in message
:

Is there a macro that can be used to list all of the VBA worksheet
functions in column A of a workbook? Thanks.

One of the problems is that worksheet functions can exist in many places.
There are the Excel built-in functions, some more in the Analysis Toolpak
that many people would consider part of basic Excel (NETWORKDAYS, etc.), and
then some that will be added by other addins.

So it is difficult.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JFM" wrote in message
...
VBA will not handle every worksheet function. Just like there are macros
that will list the name of every font that can be used, I'm wondering if
there is a macro that will extract a list of every worksheet function that
can be used with VBA and then copy that list to a worksheet range.

"Alan Beban" wrote:

JFM wrote:
Is there a macro that can be used to list all of the VBA worksheet
functions
in column A of a workbook? Thanks.
I know what Worksheet functions are. What do you mean by *VBA*
worksheet functions?

Alan Beban