Sunday, October 25, 2020
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

Here's how to boost your Excel output, slash your Excel errors, and improve your Excel reports and analyses—whether you work for a large or small company.

How to Be Significantly More Productive in Excel

The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...
Use this Excel dashboard to track 27 economic indicators of the United States' recovery from the Covid-19 recession.

Learn How to Use Excel to Track the US Recovery from the Covid Recession

The Covid recession is the worst recession the world has experienced since the Great Depression. And the Recovery Tracker workbook and Excel training can...
This Excel dashboard report lets you follow key economic trends while showing you how to gain a HUGE increase in your Excel productivity at work.

Track Key Economic Indicators Every Weekday with this Excel Dashboard

You can update this Excel dashboard report every weekday—with one command—if you have Excel 2016 or above. This report of current economic data introduces you...
Advertisement
Advertisement