Faster Excel Calculations By Minimizing Range Boundaries
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.
VBA
Counting Based on Background Color in Excel
How to count all Excel cells in a range based on background color using a custom user-defined function in VBA.
Concatenate Ranges, Arrays, and Values Using Excel 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.
Display Excel File Modified Date in Power BI
How to display the last modified date of the underlying source Excel data file used in a Power BI report.
Creating Cascading Drop-down Lists in Excel
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.
Automate E-mail Information Extraction from Outlook into Excel Using VBA
How to automate the extraction of information from e-mails in Outlook into Excel using a custom VBA procedure.
Retrieve Outlook Address Book Data Using Custom Excel VBA Function
Custom VBA Excel function to retrieve individual data attributes from Outlook address book entries.
Parse Cell Value in Excel Using Regular Expressions
How to parse an Excel cell value using regular expressions. This function returns cell value substrings that match the regex pattern.
Import Worksheets From One Workbook to Another Using VBA
Excel VBA procedure to programmatically import worksheets from one closed workbook into a different Excel workbook.