Time is Slipping Away

Ten days ago (on May 7) I mentioned that I had finally updated my popular ExcelTips: The Macros e-book. What I may not have mentioned is how much it really was updated.

This 12th edition now contains over 1,450 pages. It includes every macro-related tip ever published in ExcelTips. That's every tip that talks about how to create or use macros, has anything to do with VBA, or includes an example of how to perform a task using a macro.

To celebrate the release of the new edition of this amazing reference, you can now get your own copy for 30% off the regular price. This offer is only good for only another few days; the celebratory sale is only in force through this coming Wednesday, May 21.

I hope you'll take a few moments to check out the full information about this definitive reference:

    https://store.tips.net/T010157

Check it out today, before time gets away from you!

—Allen
     

ExcelTips (menu) for 17 May 2025

Online and web
Extracting URLs from Hyperlinks

When you add a hyperlink to a worksheet, it consists of a minimum of two parts: display text and URL address. If you have a whole series of hyperlinks from which you want to extract the underlying address, this can be a tedious challenge. There are easy ways to get the required info, however.

Read this tip »

 
Formulas
Finding the Nth Occurrence of a Character

The FIND and SEARCH functions are great for finding the initial occurrence of a character in a text string, but what if you want to find an occurrence other than the first? This tip presents a couple of ways that you can find exactly the occurrence you need.

Read this tip »

 
Enhance Your Excel Skills with Macros

Macros are a great way to increase your productivity with Excel by making the program work the way you want it to work. Discover the true power behind macros; ExcelTips: The Macros puts almost 800 pages of macro-focused information at your fingertips. Discover more...

 
Cell formatting
Referencing External Cell Colors

If you want to reference cell colors external to your current workbook, there is no way to do it using Excel functions. You can, however, create your own macro that will do the referencing for you.

Read this tip »

 
Date and time functions
Using Excel for Timing

Excel allows you to store times in a worksheet. If you want to use Excel to time certain events, there are a couple of ways you can approach the task.

Read this tip »

     

Special Note!

I've been publishing ExcelTips for years. Decades, actually. The newsletter you are reading right now is for very old versions of Excel. I still publish it because I know that some people are still using very old versions of Excel. Most people, however, are using newer versions of the program. If you are are using a newer version of Excel (2007, 2010, 2013, 2016, 2019, 2021, or the version in Microsoft 365), then you should seriously consider changing to the version of the newsletter designed for you. You can do so by clicking this link.

Thanks for your support of ExcelTips, and I hope you enjoy whichever version of the newsletter you receive. If you have any questions, just let me know.

 
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