Excel 2007 can sort and filter using the cell color (colour). By using a UDF you can do this in earlier version as well. VBA can get the interior color of the cell and report it as an index number from 1 to 56. Add this code into the VBA editor and add a column to you data with the formula =CellColor(A1).

Function CellColour(cell As Range)
CellColour = (cell.Interior.ColorIndex)
End Function


You can now sort or filter using this data. It’s not quite as clever as the latest version but you can still use colours to sort and filter.

You might find the following table helpful to understand the colours used in Excel. Thanks to www.mvps.org for the table.

This is excellent. I have been looking for a way to get a list of files in a directory into Excel so that I can determine which are new. The contents change over time. I found this here

I put the following code from ask.metafilter.com into the module of my file (using Alt+F11). I can now play with the code to give me the file attributes I need. This code will give you Filename, Size, Created, Modified , Accessed, Full path.

Option Explicit
Sub GetFileList()
Read more »

I recently exported some emails from Outlook into an Excel file. I wanted to get the contents into a file so that I could use the address details that had been in the emails.
Outlook exports the email body into one cell and adds carriage returns to the text. I needed to convert the carriage returns and “box” characters into something that I use to to Delimit the text.

This is what I did. I created the following VBA routine. The first line takes out the carriage returns and replaces them with a semi colon. The second line replaces the box characters with a tilde.
Sub fixme()
ActiveSheet.UsedRange.Replace what:=Chr(10), replacement:=";" 'this is the carriage return
ActiveSheet.UsedRange.Replace what:=Chr(13), replacement:="~" 'this is the box character
End Sub

I can then highlight the text and convert it to columns using the Text to Columns feature in Excel.