WHere can I find a list of ColorIndex colors?

[Christiane]

When I use .font.colorindex = 5 for example, I put the number
randomly.

Is there a way to find out what numbers represent which color?

Thanks.

How come when I type *.font.* I don't see a list of values I can pu
like size or colorindex, etc.

Thanks

 

[Frank Kabel]

Hi
have a look at
http://www.mvps.org/dmcritchie/excel/colors.htm

 

[kkknie]

As for your second question, some objects handle the autocomplete an
others don't. For example, typing:

Range("A1").Font.

will give you a list of options, while:

cells(1,1).Font.

will not.

 

[Steve Cross]

Christiane,
Put this code into a macro and run it on a new empty worksheet. It will give
you a colour sheet of the whole rang. They are numbered from 0 to 56 and
some are quite similar to each other.
Steve

For n = 0 To 56
Range("A" & Trim$(Str$(n + 1))) = n
Range("B" & Trim$(Str$(n + 1))) = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
Rows(Trim$(Str$(n + 1)) & ":" & Trim$(Str$(n + 1))).Select
Selection.Font.ColorIndex = n
Next n
Columns("A:B").Select
Selection.Columns.AutoFit
Range("A1").Select