Hi Mattew,

ClearContents removes values.

Clear removes contents and formats.


---
Regards,
Norman



"Mattew" wrote in message
...
I'm trying to clear all cells in a worksheet with clearcontents. But I'm
wondering if it can also change the font colorindex of those cells whose
color have been changed in the previous actions. I can't find any
information
about this. Would you please tell me your experiences? Thanks a bunch!