VBA

Function	Description	Documentation
AreArraysEquals	Checks if two arrays are equal	📄
AutoFillFormulas	Automatically fills formulas across a range using a reference cell's formula	📄
CleanString	Cleans a string by removing or replacing special and control characters with spaces	📄
DisableRefreshAll	Disables the "Refresh All" option for all OLEDB connections in a workbook	📄
EnableRefreshAll	Enables the "Refresh All" option for all OLEDB connections in a workbook	📄
FileExists	Checks if a file exists at the specified file path.	📄
FileNameIsValid	Checks if a given name can be used as a valid file name	📄
GetAllFileNames	Retrieves an array of all file names from a folder and its subfolders	📄
GetLetters	Extracts ASCII letters from a string, in lowercase/td>	📄
GetMonthNumberFromName	Converts a month name to its corresponding numeric value	📄
GetStringBetween	Extracts a string between two specified delimiters	📄
GetStringWithSubstringInArray	Searches through an array of strings and returns the first string that contains a specified substring	📄
GetTableColumnNames	Returns the column names of an Excel table	📄
IsAllTrue	Checks if all elements in a boolean array are True	📄
IsInArray	Checks whether a value exists in an array	📄
ListObjectExists	Checks whether a ListObject (Excel table) exists in a workbook	📄
PreviousMonthNumber	Returns the month's number that precedes the month of a given date	📄
RangeHasAnyFormula	Checks if a range contains any cell with formulas	📄
RangeHasConstantValues	Checks if a range contains any constant (non-formula) cell	📄
RangeIsHidden	Checks if a range has no visible cell	📄
RangeToHtml	Converts a range into an HTML string	📄
SendEmail	Sends an HTML email using CDO with NTLM authentication	📄
SetQueryFormula	Sets a Power Query formula for a query in the current workbook	📄
StringContains	Checks if a string contains a substring	📄
StringEndsWith	Checks if a string ends with a specified substring	📄
StringStartsWith	Checks if a string starts with a specified substring	📄
SubstringIsInArray	Searches a array for any string element that contains a specified substring and returns True on the first match	📄
Summation	Computes the numeric summation of a mathematical expression over an integer index range	📄
TableHasQuery	Checks if a ListObject (Excel table) is associated to a query	📄
WorksheetHasListObject	Checks if a worksheet contains a ListObject (Excel table)	📄