Hello,

What i've typed doesnt work, and i'm wondering if i could have advic
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