question about ClearContents

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!

Hi Mattew,

ClearContents removes values.

Clear removes contents and formats.


---
Regards,
Norman



"Mattew" <[email protected]> wrote in message
news:[email protected]...
> 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!