Color Index for Excel VB
Posted by Paul Magruder on May 02, 2001 7:51 AM
Does anyone know where I can find the color index excel uses for cell interior?
Red = 1?
blue = 2?
Thanks in advance
Paul
Posted by lenze on May 02, 2001 9:28 AM
Open the Visual Basic Editor and choose help. Type in Color Index<Search and you can view a color chart
Posted by Bj on May 02, 2001 11:36 AM
Try this to...
Sub Color()
For x = 1 To 56
Cells(x, 1).Select
Cells(x, 2).Value = x
With Selection.Interior
.ColorIndex = x
End With
Next x
End Sub
