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 the [...]
Posted on October 19th, 2005 by Bastien
Filed under: ASAP Utilities, General | 3 Comments »
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.
Is it [...]
Posted on October 19th, 2005 by Bastien
Filed under: General | No Comments »
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 [...]
Posted on October 14th, 2005 by Bastien
Filed under: ASAP Utilities | 3 Comments »
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 [...]
Posted on October 7th, 2005 by Bastien
Filed under: ASAP Utilities | 5 Comments »
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 [...]
Posted on October 6th, 2005 by Bastien
Filed under: ASAP Utilities | 1 Comment »
(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 [...]
Posted on October 4th, 2005 by Bastien
Filed under: ASAP Utilities, General | 4 Comments »
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 [...]
Posted on October 4th, 2005 by Bastien
Filed under: ASAP Utilities | No Comments »
Excel 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 [...]
Posted on October 2nd, 2005 by Bastien
Filed under: Excel 2007 info | No Comments »
