There are several things that can affect the speed of Excel or cause startup problems. I've found five good sites that discuss these problems and offer solutions: Chip Pearson: Startup Errors In Excel Microsoft: How to troubleshoot startup problems in Excel David McRitchie: Slow Response, Memory Problems, and Speeding up Excel JKP: Fixing Startup problems Contextures: Answers to Frequently Asked Questions ...

I just got a call from a friend of mine. He needed to edit a spreadsheet and round a bunch of formulas. Since the rounding is important for the calculations, a simple cell-formatting wouldn't do. Excel's worksheet function =ROUND() can be used to round the numbers. However editing a lot of cells by hand (especially with ...

It has been on of those 'spam-periods' again. My inbox this morning: Fortunately most spam is detected and all virussus are removed, but still a lot of rubbish comes through the filters. I use Outlook 2003 and I have also tried Thunderbird (Mozilla) but still too much spam comes through in both mail clients. My list of ...

Jeremy (US) asked me a question about coloring based on a cells value: First your product ASAP Utilities is great and has been a life saver. One feature that would be outstanding is a conditional row color based on a cell value. For instance there are numerous times I have to color a row because the value ...

I'm working on an ASAP Utilities User Guide. When describing some of the worksheet function that use the colorindex property, I needed a good example of all available colors. So I wrote a quick macro to create a colorindex-table but enhanced it to show the colors in the same order as it is shown in ...

Yesterday I got a question about the unit system in Excel. Andy from down under wrote: I am not a huge user of all the complex stuff that excel does but your ASAP has made my work easier. Simple thing like changing case when I've left the caps lock on!! I do have a question for you. ...

(Update October 18, 2007: If you want an easier way to do this, see this post: Video: How to sort by color in Excel with ASAP Utilities) In Excel you can only sort by value, not by formatting such as cell colors. With ASAP Utilities you can! Here's a short example how to do sort by ...

Hello world! This blog will be use to post frequently about Excel tools and provide code snipplets. As the author of ASAP Utilities I get a lot of questions by email. Most questions are the same and repeated over and over again. I'll use this blog to answer to the most general Excel questions including questions ...

A few weeks ago I got a question about hyperlinks. A list of soccer clubs was kept in Excel (4000+). Some of them had a hyperlink some didn't. How to see this quickly? A possible solution is to show them in different colors: Private Sub ColorHyperlinks()  ' color cells with hyperlinks  Dim rngCel                                 As Range  Application.ScreenUpdating = False  For Each rngCel ...

Last week I got a question from Mike: Bastien, Thank you for writing ASAP Utilities. It has saved me countless hours in Excel time and has given me capabilities that I wouldn't otherwise have. I wanted to ask for some help. I noticed that in the user-defined functions for ASAP Utilities there is a function "ASAPSumbyFontColor". I ...