Excel calculation speed can be improved by reducing the size of an evaluated range. This custom VBA function removes empty boundary cells from a range.
How to count all Excel cells in a range based on background color using a custom user-defined function in VBA.
How to concatenate ranges, arrays, and values in Excel using a custom function with options for a delimiter and setting row or column priority.
How to display the last modified date of the underlying source Excel data file used in a Power BI report.
How to create cascading drop-down lists in Excel. Selecting an option in the parent cell filters the available options in the dependent child cell.
How to automate the extraction of information from e-mails in Outlook into Excel using a custom VBA procedure.
Custom VBA Excel function to retrieve individual data attributes from Outlook address book entries.
How to parse an Excel cell value using regular expressions. This function returns cell value substrings that match the regex pattern.
Excel VBA procedure to programmatically import worksheets from one closed workbook into a different Excel workbook.