| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range("A1").Interior.ColorIndex=xyz does not work
Hello Group,
I try to set Cell Background-Color with Range("A1").Interior.ColorIndex=xyz but does not work while I can read out the value and it is different when I set it with Cell Format in Excel manualy if I set it from vba it isn't so red back again |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range("A1").Interior.ColorIndex=xyz does not work
What do you mean by does not work. Does it throw an error or does it just not
do anything. Since you do not specify a worksheet in the code line are you sure it is acting on the correct worksheet??? Worksheets("Sheet1").Range("A1").Interior.ColorInd ex=34 might fix your problem. -- HTH... Jim Thomlinson "iwl" wrote: Hello Group, I try to set Cell Background-Color with Range("A1").Interior.ColorIndex=xyz but does not work while I can read out the value and it is different when I set it with Cell Format in Excel manualy if I set it from vba it isn't so red back again |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Error 1004 Unable to set the ColorIndex property of the Interior. | Excel Programming | |||
| "COUNTIF" using ".ColorIndex" and "AND" | Excel Programming | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| Cell.interior.colorindex - does not work in Excel 97 | Excel Programming | |||
| Why doesn't "Workbook.Range("myrange").value" work? | Excel Programming | |||
Linear Mode
