Mark,

There is no colorindex of 0, so I guess 2003 has just tightened up.

Try

Range(cell_dest).Font.ColorIndex = xlColorindexAutomatic

if using the Interior property, use xlColorindexNone.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"MarkT" wrote in message
...
I have recently upgraded from Office 2000 to 2003 Pro. I have a
spreadsheet
containing VBA code that halts when run in 2003 with the following
'unexpected error':

Unable to set the ColorIndex property of the Font class

Code execution then stops. Here is the offending code line

Range(cell_dest).Font.ColorIndex = 0

I have tried changing the value to no effect and cannot find anything
about
this error anywhere in the KB or newsgroups. Using VBA 6.3 in both 2000
and
2003 setups.

Any ideas anyone - this spreadsheet is critical to my work!

Tks
Mark