Recently I have been receiving a few emails about people telling me that their Excel 2007 would startup very slowly with ASAP Utilities installed. The delay also occurred without ASAP Utilities if they click on an Excel file from within the Explorer: If I click on an xls file Excel opens with a blank window which [...]
Posted on July 9th, 2007 by Bastien
Filed under: ASAP Utilities, Excel 2007 info, General | 61 Comments »
Microsoft has written an article on how some things in Excel can be done without the use of macro's. An interesting list. However I remember that back in 1999 when I use their approach to "Exclude duplicate items in a list" I found out that this was limited to approximately 1000 unique items. This article [...]
Posted on June 21st, 2007 by Bastien
Filed under: General | 2 Comments »
By default, Excel keeps track (allocates RAM) of 16 "undo" levels. Undo levels provide an undo history for most actions that you perform in Excel. You can change the number of undo levels by adding an entry in the Microsoft Windows registry. If the undo history is set to zero, no memory is allocated for [...]
Posted on May 28th, 2007 by Bastien
Filed under: General | Comments Off
There are several ways to copy information from one sheet to another. Today I discovered an inconsistancy while using something similar like the following code: Sheet1.Range("A1:A100").Value = Sheet2.Range("A1:A100").Value The above code does not work correctly if the cells in sheet 2 are formatted in currency- or accounting format. In that case Excel does not copy [...]
Posted on April 24th, 2007 by Bastien
Filed under: General | 1 Comment »
I have been getting a lot of comment spam on this blog. I've just removed over 20.000 comments from the database. Apparently WordPress still stores the comment if you mark it as spam. I haven't looked in the code if it uses this for some clever techniques to detect future spam. Right now I just [...]
Posted on April 19th, 2007 by Bastien
Filed under: General | 3 Comments »
Today my Outlook was messed up a bit and several rules didn't work correctly any more. I had a good backup but I found out that if I imported the rules-backup, the original rules were not replaced but instead the imported rules were added to the list. So you need to remove all all the [...]
Posted on February 9th, 2007 by Bastien
Filed under: General | 18 Comments »
When you install the new Office 2007 the first thing you want to do is show the developer tab. You should display the Developer tab or run in developer mode when you want to write macros, run macros that you previously recorded, or create applications to use with Microsoft Office programs. Click the Microsoft Office [...]
Posted on February 5th, 2007 by Bastien
Filed under: Excel 2007 info, General | Comments Off
Just got a question that migh be interesting to show here about columns that are displayed backwards. The columns are in reverse alphabetical order and start at the upper right hand corner. The row numbers are on the right side of excel instead of the left. The Problem: Recently, when I opened Excel, the columns [...]
Posted on January 3rd, 2007 by Bastien
Filed under: General | Comments Off
Inserting multiple rows "the Excel way" If you want to insert multiple rows at once the standard procedure is to first select multiple rows and then use the "Insert" command. For example if you want to insert 10 rows between A1 and A2, you first have to select rows 2:11 and then insert the rows. [...]
Posted on November 13th, 2006 by Bastien
Filed under: General | 3 Comments »
Last week I got a question from Amit: I use the asap utilities a lot and it is great help. My question is regarding cell coloring. I'd like to be able to assign only two colors to a cell. For example, say if you select a cell once (or click on it once), it turns [...]
Posted on October 1st, 2006 by Bastien
Filed under: General | 1 Comment »
