Just for reference...

Activecell.Clearcontents will clear the contents of the cell, but leaves the formatting intact. If you want to wipe everything (formats & values) from the cell, you could use:

[vba]Activecell.Clear[/vba]

I find that for most of my applications, that I prefer to leave the formatting of a cell alone once I've set it up. Clear does have it's uses sometimes, though.