Interior.ColorIndex

[matrixknow]

I know you have a limited number of VB Constants like vbBlue. How can I find a way or list to find the corresponding number for a certain color. eg. I look for light gray.

 

[HughLerwill]

Try stuff like;

Const Blue = 37, Yellow = 19, Green = 35, Grey = 40, Red = 4

ActiveWorkbook.Colors(37) = RGB(191, 235, 255) 'modify the standard Blue
ActiveWorkbook.Colors(4) = RGB(255, 202, 202) 'modify the standard Red

Range(Cells(4, 1), Cells(5, colLast)).Interior.ColorIndex = Blue
Range(Cells(6, 1), Cells(rowLast, colLast)).Interior.ColorIndex = Yellow

 

[xlbo]

For i = 1 to 56
 cells(i,1).interior.colorindex = i
Next i

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[ClulessChris]

http://www.mvps.org/dmcritchie/excel/colors.htm

Everybody body is somebodys Nutter.

 

[matrixknow]

thanks to all, nice and complete references !