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

--
Message posted from http://www.ExcelForum.com

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

-----Original Message-----
When I use .font.colorindex = 5 for example, I put the
numbers
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 put
like size or colorindex, etc.

Thanks.


---
Message posted from http://www.ExcelForum.com/

.

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.



--
Message posted from http://www.ExcelForum.com

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


Christiane wrote in message
...
When I use .font.colorindex = 5 for example, I put the numbers
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 put
like size or colorindex, etc.

Thanks.


---
Message posted from http://www.ExcelForum.com/