Saturday, September 25, 2021
When you record VBA macros, Excel records each item you select. Here's why and how to avoid selecting those objects in your actual macro.

You Usually Don’t Need to Select an Object in Excel VBA

An Excel VBA user asked in a forum recently how to select a sheet in VBA when the sheet name is stored as a...
Excel tracks many worksheet properties that formulas don't return. But you can fix the problem in VBA by writing a UDF, a User Defined Function.

Use VBA Functions to Return Excel Document Properties

"I would like to add a small formula-driven reference in my Excel worksheets that: (1) Automatically notes the original author/user (or last modifier) of...
Here's how to use both VBA and iterative calculations to update your workbook in response to DDE updates. Also includes ideas from other Excel MVPs.

Track Dynamic Data with VBA or with Iterative Calculations

"My A1 cell changes value every minute because it imports data from a DDE server. To keep historical data, I would like to list...
Read a Text File with VBA in Excel, and Write the Text to a Spreadsheet

Read a Text File with VBA in Excel, and Write the Text to a...

"I need to write a text file into one row of my Excel spreadsheet, cell by cell, 20 characters at a time. It's urgent....
In VBA, you'll save time and frustration by always declaring your variables and by also using Hungarian notation. Here's why and how to do that.

Declaring Variables in VBA: Three Keys for Success

A recent post in an Excel forum included some VBA code and asked why the code kept failing. The first few lines of code...
It makes sense to document your VBA programs. Here are four easy ways to help yourself and others know what your VBA programs are trying to do, and why.

Corporate VBA Standards for Excel Users Who Program

(Update: To see an illustration of the points I discussed here, see Read a Text File with VBA, And Write the Text to Excel.) In most...
This simple VBA procedure finds the precise time it takes to calculate a workbook. You can use it to test competing workbook design methods.

Use Excel VBA to Test Report Calculation Times

I once exchanged email with an experienced Excel jockey who insisted that VLOOKUP was Excel’s fastest lookup method. It was even faster, he said,...

Latest Articles

Two unusual formulas can use the SEARCH or FIND functions to search any number of cells for any number of words—almost instantly.

How I Set Up SEARCH and FIND Formulas on Steroids

I've used Excel long enough to recognize when I've stumbled across an unusual formula. And it happened again a few minutes ago. In the past,...
Use this unique Excel dashboard to track the general rate of inflation, your personal rate, and the rate of the goods and services you buy.

Inflation Tracker Excel Dashboard with Consumer Prices

U.S. President John F. Kennedy once said of a growing economy, "A rising tide lifts all boats." However, a rising inflationary tide does not lift...
Excel's Quick Access Toolbar can save you many clicks and needless work. Here are the eight QAT tools that I use, and how I use them.

Eight Great Tools for Your Quick Access Toolbar

I use eight great tools in my Quick Action Toolbar (QAT), and you might want to consider using them yourself. Before I get into the...
Advertisement
Advertisement