With ActiveCell
.Interior.ColorIndex = xlNone
.Font.ColorIndex = xlAutomatic
End With

type colorindex in your module, highlight it an hit F1. This has that
information.

turn on the macro recorder and make those changes manually - then turn it
off and look at the code - another way.

--
Regards,
Tom Ogilvy

"Frank" wrote in message
...
I want to set the font color index of a cell
to 'automatic' and the fill color to 'no fill'.

I don't see the index number in the color chart in Excel's
help.

What are the Color Index #s for 'automatic' font and 'no
fill'

Thanks for your help