vba: setting font color to entire sheet
 

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

setting font color to entire sheet
 

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/

setting font color to entire sheet
 

try using the sheet name
Sheets("Sheet4").Cells.Font.ColorIndex = 0

--
Don Guillett
SalesAid Software

"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/

vba: setting font color to entire sheet
 

THANK YOU!!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/