Is it possible to select by colour?

A question I received today from Daniel (Mexico City) : I will like to suggest you the possibility of including in the formula menu a funtion like "Hide Formula Errors" to stop the anoing NA or VALUE? Thanks for making this kind's of tools for excel, from now on hopefully I will spend less time in making ...

Rename ASAP Utilities directory

Yestday Graham (UK) asked me the following question: Dear Bastien, I tried to re-name the ASAP directory to avoid getting it confused with another directory used by Windows XP. I re-installed your program to another directory but now find Excel still looks for the old directory. How do I prevent Excel from looking for a now non-existent directory? Many ...

Excel 12 : "save as PDF"

Office 12 : save as PDFExcel and some other Office 12 applications will have a "save as PDF" function. This was posted yesterday by Dick Kusleika (Daily Dose of Excel) and Chris Pratley (Chris_Pratley's OneNote WebLog) who both joined the 2005 MVP Summit. A quote from Cris' website: Today was a fun day. It was our last day with our MVPs visiting ...

Some other numbers on Excel 12

Last monday David Gainer from Microsoft has posted more details on Excel 12 on his weblog. Much of the new expanded limits have to do with the new grid. http://blogs.msdn.com/excel/archive/2005/09/26/474258.aspx Personally I really like the new grid. More rows and more columns allow you to import more data for analysis.

ASAP Utilities in Russian edition of PC Magazine

"This expansion module is required for all users."

Yesterday I discovered ASAP Utilities is mentioned in the Russian edition of PC Magazine on September 15, 2005: I don't read Russian but I believe it's the same article that has been published by PC Magazine in its 2005 Ultimate Utility Guide. Russian to English translation by Google Translate: Microsoft Excel There are hundreds of specialized plug-ins for Excel, ...

Extract hyperlinks

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

Sum by cell color

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

Cool Site of the Day in the Kim Komando Show

Kim KommandoASAP Utilities is being featured in The Kim Komando Show Cool Site of the Day on August 8, 2005. Kim Komando hosts the largest talk radio show about computers and the Internet. The program is heard on over 450 stations throughout the United States. Kim Komando's newsletter has hundreds of thousands of subscribers. For:8/8/2005 Tweak Excel I've used ...

Bug fixes in version 3.10

False Virus alert in sytem.asap Gone ?Some virusscanners reported a virus in the file system.asap.Of course ASAP Utilities is virus-free, but it caused a lot of "stress". The reason was caused by the codeline: insertline() which was in the System » Macro/VBA information » Code washer part. Here you can choose to remove empty lines, ...