| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range("A1:A10").Interior.ColorIndex = Xlnone
Hi,
I may write this : Range("A1:A10").Interior.ColorIndex = 0 But i could write this too ... '--------------------- Dim x As Excel.Constants x = xlNone Range("A1:A10").Interior.ColorIndex = x '--------------------- The value of Xlnone = -4142 Any explanations why both methods work ? Thank for your collaboration and help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range("A1").Interior.ColorIndex=xyz does not work | Excel Programming | |||
| "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 | |||
| colorindex = xlnone on condition of month of year | Excel Programming | |||
Threaded Mode
