The Tenth Edition

This past week I sent out a message to all of my subscribers about the fact that I updated my ExcelTips: The Macros e-book. It's been almost exactly two years since I updated it, and I finally made it available this past week.

It is pretty amazing to me that I'm now releasing the 10th edition of this title, and it has reached over 1,230 pages of content. That's a *TON* of information on how to work with macros!

This edition is revised and expanded from previous editions--as you should expect--providing the most up-to-date information possible about programming Excel macros.

ExcelTips: The Macros, tenth edition, includes every tip related to macros that has ever been published in over two decades of ExcelTips, all in one convenient e-book. There's too much in this edition to cover here, but I'd invite you to go and take a look:

https://store.tips.net/T010157

The page includes complete details, including information on how the new edition is available, for a limited time, for 30% off the regular price. (That means you can get an immediate download, if you choose, for only $26.59.)

Don't delay; this special offer is available only for the next ten days or so; it ends on May 19, 2021.

Thanks for your continued support of ExcelTips!

—Allen
     

ExcelTips (menu) for 8 May 2021

Editing
Shortcut for Selecting a Data Range

Want to select all the data in a contiguous section of a worksheet? The shortcut discussed in this tip makes it very easy.

Read this tip »

 
Formulas
Combining Numbers and Text in a Cell

There are times when it can be beneficial to combine both numbers and text in the same cell. This can be easily done using a formula, as described in this tip.

Read this tip »

 
Pay a Visit to Formville

Need invoices, statements, receipts, applications, and hundreds of other business forms you can put to use right away? How about if you can get those forms for free? Discover what awaits you in Formville, your destination for free printable business forms.

 
Find and Replace
Find and Replace in Headers

Using Find and Replace is something quite routine in Excel, as it easily allows you to find and replace information in your worksheets. What if you want to find and replace information in headers or footers, however? That isn't quite as easy.

Read this tip »

 
Files
Checking for the Existence of a File

The data stored in a worksheet can often correspond to information external to that worksheet. For instance, you might collect data that represents filenames in a directory somewhere. If you want Excel to check whether those collected filenames exist, it's easy to do using a simple macro.

Read this tip »

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450