Below is a list of Excel VBA functions sorted alphabetically. If you would like a list of these functions sorted by category, click on the following button:Sort AlphabeticallySearch VBA functions: (Enter a value in the field above to quickly find functions in the list below)...
Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column. Our 10 featured functions Compatibility Cubes Database functions Date and ...
Excel functions (by category) Overview of formulas in Excel How to avoid broken formulas Detect errors in formulas Need more help? Want more options? DiscoverCommunity Explore subscription benefits, browse training courses, learn how to secure your device, and more. Microsoft 365 subscription be...
You'll use the CONTOSO namespace to access the custom functions in Excel. Next, try out the ADD custom function by completing the following steps. In Excel, go to any cell and enter =CONTOSO. Notice that the autocomplete menu shows the list of all functions in the CONTOSO namespace. Run...
You can use Excel to perform a variety of automatic, manual, and iterative calculations. Excel uses functions to perform these calculations. For more information, seeExcel functions by category. Cell references in formulas You can use cell references in formulas. When yourefer to a cell or a...
Here you will find a detailed tutorial on 100+ Excel Functions. Each function is covered in detail with a practical Examples and Video.
Here I have listed the Top 100 VBA Functions (Category Wise) in detail with examples and sample codes. These functions are listed under specific categories (10) to help you understand the purpose of each function easily. Below is the list of categories of the major VBA functions. All the ...
You can also browse through Excel's extensive library of functions. In the ribbon, click Formulas. Select Insert Function. To browse functions by category, click the Select category dropdown. Click on any function, and a description of how it works appears beneath the list of functions. ...
Such INDEX formulas can hardly be used on their own, because Excel is unable to fit the array of values returned by the formula in a single cell, and you would get the #VALUE! error instead. However, if you use INDEX in conjunction with other functions, such as SUM or AVERAGE, you ...
public static object ListUdfDesc() { List<string> list = new List<string>(); var funcs = ExcelRegistration.GetExcelFunctions(); foreach (var funcInfo in funcs) { string name = funcInfo.FunctionAttribute.Name; string desc = funcInfo.FunctionAttribute.Description.Replace("Excel催化剂出品,必属...