Trimming Spaces from Strings

Need to get rid of extraneous spaces before or after the text in a string? VBA provides three different functions you can use to make the removal quick and easy.

Read this tip »

Finding Cells Filled with a Particular Color

Do you need to find cells that are formatted with a particular color? How you accomplish this task depends on your version of Excel.

Read this tip »

Macros! Macros! Get Your Macros Here!

Learn all the best methods for creating and using Excel macros. ExcelTips: The Macros is the best single source for learning about macros or improving your existing skills. Be the person everyone looks to when something needs to happen in Excel. Get yours today!

Specifying a Paper Tray in a Macro

If you are using a macro to create your printed Excel output, you may need a way to specify that paper should come from a specific printer tray. That is not as easy as it may first seem. Here's a discussion on the options you have.

Read this tip »

Links to Hyperlinks

Hyperlinks in a worksheet can be helpful or essential, depending on the nature of your data. If you create a link to a hyperlink, you may wonder why the link doesn't act the same as the original hyperlink. Here's why.

Read this tip »

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.