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...
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...
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...
"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....
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...
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...
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
Getting Radical with Excel
It's time to think about Excel in a radical new way—when we use it to work with business or economic data.
It's time, in fact,...
How Fast Is Too Fast?
(Originally published in Inc Magazine.)
What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...
How to Smooth Data by Using the TREND Function
Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...
Advertisement