Thursday, February 22, 2024
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

Whoops! We’ve Got a Broken Home Page!

Sorry about that. We're working on it. Hope to get it fixed soon.
Excel Flowbook Revolution

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,...
Growing too fast can be dangerous to your company's health. Use the Sustainable Growth Rate ratio to track your company's financial ability to grow.

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...
Advertisement

dumanbetyenigiris.com

asyabahisgo1.com

pinbahisgo.com

sekabet

olabahisgo.com

maltcasino-giris.com

faffbet-giris.org

1xbet-persian.com

3btforward1.com

megapari-farsi.com

melbet-farsi1.com

bet-winner.top

betnub.info

sekabetgo.com

betforward1.org

1xbet-adres.com