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 the original [...]

Posted on April 24th, 2007 by Bastien
Filed under: General | 1 Comment »

I'm still not sure about which format to choose and I don't like my own voice, but here is the first tutorial:
The following video will demonstrate you how to deselect cells in Excel with ASAP Utilities.

Posted on April 23rd, 2007 by Bastien
Filed under: ASAP Utilities, Video | Comments Off

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 »

Array formulas can help you in Excel to perform complex calculations, expecially if you want to do calculations with certain or multiple criteria.
Here are a few links that provice more information and examples on how to use them:
http://www.cpearson.com/excel/array.htm
http://www.mrexcel.com/tip011.shtml
http://office.microsoft.com/en-us/excel/HA010872901033.aspx
http://www.pcmag.com/article2/0,4149,1265433,00.asp
http://www.exceltip.com/exceltips.php?view=category&ID=106
http://tech.yahoo.com/gd/building-an-array-formula-in-excel/153304
http://support.microsoft.com/kb/275165
http://www.bettersolutions.com/excel/EDK153/LT423111411.htm

Posted on April 2nd, 2007 by Bastien
Filed under: ASAP Utilities | Comments Off