| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ColorIndex property XL2000 vs 2003
I have recently upgraded from Office 2000 to 2003 Pro. I have a spreadsheet
containing VBA code that halts when run in 2003 with the following 'unexpected error': Unable to set the ColorIndex property of the Font class Code execution then stops. Here is the offending code line Range(cell_dest).Font.ColorIndex = 0 I have tried changing the value to no effect and cannot find anything about this error anywhere in the KB or newsgroups. Using VBA 6.3 in both 2000 and 2003 setups. Any ideas anyone - this spreadsheet is critical to my work! Tks Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DataLabel.Font.ColorIndex vs DataLabel.Text (Private Sub does not work in excel 2003) | Charts and Charting in Excel | |||
| Excel 2003 template for income producing commercial property | Excel Discussion (Misc queries) | |||
| Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
| unable to set the colorindex property of the font class | Excel Programming | |||
| Unable to set the colorIndex Property of the Interior Class Error | Excel Programming | |||
Threaded Mode
