| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tab.colorindex linked to cell color | Excel Worksheet Functions | |||
| ColorIndex | Excel Worksheet Functions | |||
| VBA ColorIndex Formatting | Excel Discussion (Misc queries) | |||
| colorindex | Excel Discussion (Misc queries) | |||
| VBA syntax for Font & Interior ColorIndex | Excel Discussion (Misc queries) | |||
Hybrid Mode
