Skip to content

John Dalesandro

  • Home
  • Blog
    • Technology
      • Automation
      • Cloud
      • Data and Analytics
      • Productivity
      • Programming
      • Security
    • Fun & Games
  • Laboratory
    • Analytical Spam Filter Plugin for WordPress
    • Micro Contact Form Plugin for WordPress
    • Head Trimmer Plugin for WordPress
    • Custom Field Embedder Plugin for WordPress
  • Site Information
    • About John Dalesandro
    • Contact
    • Privacy Statement

VBA

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.

Categories Productivity Tags Excel, VBA Leave a comment

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.

Categories Productivity Tags Excel, VBA Leave a comment

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.

Categories Productivity Tags Excel, VBA Leave a comment

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.

Categories Data and Analytics Tags Excel, Power BI, Power Query, VBA Leave a comment

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.

Categories Productivity Tags Excel, Macro, VBA Leave a comment

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.

Categories Automation Tags Automation, Excel, Outlook, VBA 7 Comments

Retrieve Outlook Address Book Data Using Custom Excel VBA Function

Custom VBA Excel function to retrieve individual data attributes from Outlook address book entries.

Categories Automation Tags Automation, Excel, Outlook, VBA 4 Comments

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.

Categories Productivity Tags Excel, Regular Expressions, VBA Leave a comment

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.

Categories Technology Tags Excel, VBA Leave a comment
Older posts
Page1 Page2 Next →

Popular Posts

  • Combination Clustered and Stacked Column Chart in Excel
  • Automate E-mail Information Extraction from Outlook into Excel Using VBA
  • Create Self-Signed S/MIME Certificates
  • Display Total Inside Power BI Donut Chart
  • How to Use Unicode Characters in Power BI

Latest Posts

  • Automatically Back Up a Linux Server to Google Drive
  • Linting WordPress Code Using Composer and PHP_CodeSniffer
  • Using Cards To Filter In Power BI
  • Accessing REST APIs with Basic Auth and API Key in Power Query
  • WordPress Database Cleanup Without Plugins (SQL Only)

Laboratory

  • Analytical Spam Filter Plugin for WordPress
  • Head Trimmer Plugin for WordPress
  • Micro Contact Form Plugin for WordPress
  • Custom Field Embedder Plugin for WordPress

Site Information

  • About John Dalesandro
  • Contact
  • Privacy Statement

Social

  • LinkedIn

Topics

  • Fun & Games
  • Technology
    • Automation
    • Cloud
    • Data and Analytics
    • Productivity
    • Programming
    • Security
Copyright © 2023 John Dalesandro. All Rights Reserved.