Exel 97 ColorIndex

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?
 
O

Otto Moehrbach

Shawn
Try it. 2007 will accept either one but the color index numbers are
different. HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help using Chip Pearsons code to count cells with color 9
Count cells with fill color and retain code - Mr. Umlas Can you he 1
Sorting by color Excel 2007 1
Continued Post - If statement and colors 8
Count using Coloured Cells 1
Change the Color of a Cell through a Macro 4
where can i get the Template Wizard with Data Tracking add in for. 1
ColorIndex Sub-Routine not working as expected 2

Top