Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cells interior/color index
How/Where do I get the color index? I used the names of the colors: Code: -------------------- For i = 1 To grpnr Select Case D1(i) Case Cells.Interior("Light Orange") grpsize(i) = 6 Case Cells.Interior("Aqua") grpsize(i) = 4 Case Cells.Interior("Plum") grpsize(i) = 3 Case Cells.Interior("Rose") grpsize(i) = 2 Case Else MsgBox "error in grouping color" End Select Next i -------------------- only to return error. -- tandavina ------------------------------------------------------------------------ tandavina's Profile: http://www.excelforum.com/member.php...o&userid=30334 View this thread: http://www.excelforum.com/showthread...hreadid=511457 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock cells based on interior color | Excel Discussion (Misc queries) | |||
Chart axes color index vs font color index | Charts and Charting in Excel | |||
Range based on interior color index? | Excel Programming | |||
Sum all cells with interior color... | Excel Programming | |||
Passing Back Color to Interior Color | Excel Programming |