Try the following to set the ColorIndex of all cells to
xlColorIndexAutomatic
ActiveSheet.Cells.Font.ColorIndex = xlColorIndexAutomatic
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"chick-racer" wrote in message
...
Hello,
What i've typed doesnt work, and i'm wondering if i could have advice
on how to set the entire worksheet to default font color.
right now i have
Worksheets(1).font.colorindex=xlautomatic
what is it supposed to be???
thanks guys..
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/