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

Keeping to ms office 97 pro 0
Need help modifying code 0
Help using Chip Pearsons code to count cells with color 9
Working outlook via vba code with xlsx - error 0
Count cells with fill color and retain code - Mr. Umlas Can you he 1
Border formatting row of cells 22
Continued Post - If statement and colors 8
why do cell values change with changes in unrelated cells 1

Top