Range.Value = Range.Value, isn't it?

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 […]

Video: How to deselect cells in Excel with ASAP Utilities

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.

Remove comment spam from your WordPress database

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 […]

Information about array formulas in Excel

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