Colour codes?

[mevetts]

Hi,

Is there any way of finding out what the numbers in VBA code correspond
to?

I think 39 = purple and 3 = red?

Cheers,

Mark.

 

[SteveG]

Mark,

Go to this site. It has them.

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

Cheers,

Steve

 

[Niek Otten]

Sub TestColor()
Dim i As Long
For i = 1 To 56
Range("a" & i).Interior.ColorIndex = i
Next i
End Sub

 

[mevetts]

Spot on, many thanks.