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)...
Worksheet functions are categorized by their functionality. 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. ...
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...
aka user-defined functions (UDF). These are VBA-based functions that extend the basics of Excel with custom functionality. Select a category to go to the functions list with short descriptions and links to examples of use
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 ...
Using the WRAPROWS and WRAPCOLS functions, do the opposite: create a 2D array of a specified width or height by “wrapping” data to the next line (just like the text in this document) once your chosen width/height limit is reached. ...
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催化剂出品,必属...
To set a customised date as the preferred format, return to the category list and select 'Custom'.In the ‘Type' box, make the changes you want using the text string samples below:=Text(cell number, "mmm")[For months as Jan–Dec]=Text(cell number, "mmmm")[For months as January–De...
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 ...
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 ...