Exel 97 ColorIndex

  • Thread starter Thread starter Shawn
  • Start date Start date
S

Shawn

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?
 
Shawn
Try it. 2007 will accept either one but the color index numbers are
different. HTH Otto
 
Back
Top