Create a colorindex table

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

How to merge rows

Last week Hugo (California) asked me to create a new tool in ASAP Utilities to create what he calls a "tickerstring". This way multiple rows in a column will be merged into the first row. But you know what? It's already available: Select the range, then in the menu select ASAP Utilities > Columns/rows > Merge row ...

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