Excel VBA List Application.WorksheetFunction

healey21

Well-known Member
Joined
Dec 22, 2009
Messages
900
Is there any VBA code that will create a list of the Application.WorksheetFunction so perhaps in Sheet 1 I could see cell A2 going down showing me like the following?
Application.WorksheetFunction.AccrInt
Application.WorksheetFunction.AccrIntM
Application.WorksheetFunction.Acos
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Hi

You can copy it directly from the help:

AccrInt Returns the accrued interest for a security that pays periodic interest.
AccrIntM Returns the accrued interest for a security that pays interest at maturity.
Acos Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is Arg1. The returned angle is given in radians in the range 0 (zero) to pi.
Acosh Returns the inverse hyperbolic cosine of a number. Number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is Arg1, so Acosh(Cosh(number)) equals Arg1.
Aggregate Returns an aggregate in a list or database.
AmorDegrc Returns the depreciation for each accounting period. This function is provided for the French accounting system.
AmorLinc Returns the depreciation for each accounting period. This function is provided for the French accounting system.
And Returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE.
Asc For Double-byte character set (DBCS) languages, changes full-width (double-byte) characters to half-width (single-byte) characters.
Asin Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is Arg1. The returned angle is given in radians in the range -pi/2 to pi/2.

...
 
Upvote 0

Forum statistics

Threads
1,215,036
Messages
6,122,794
Members
449,095
Latest member
m_smith_solihull

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top