Exel 97 ColorIndex
 

I have a code I wrote in Exel 97 that used "ColorIndex". In Exel 2007 I just
get "Color" when I record a macro. I need to change the color of some cells.
This macro will need to work in both Excel 97 and Excel 2007. Will using
"Color" instead of "ColorIndex" cause an error in Excel 97?
--
Thanks
Shawn

Exel 97 ColorIndex
 

Shawn
Try it. 2007 will accept either one but the color index numbers are
different. HTH Otto
"Shawn" wrote in message
...
I have a code I wrote in Exel 97 that used "ColorIndex". In Exel 2007 I
just
get "Color" when I record a macro. I need to change the color of some
cells.
This macro will need to work in both Excel 97 and Excel 2007. Will using
"Color" instead of "ColorIndex" cause an error in Excel 97?
--
Thanks
Shawn