Thread: ColorIndex
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default ColorIndex

clara

See David McRitchie's site for the color palette.

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

Or just run this macro from John Walkenbach

Sub ListColorIndexes()
Dim Ndx As Long
Sheets.Add
For Ndx = 1 To 56
Cells(Ndx, 1).Interior.ColorIndex = Ndx
Cells(Ndx, 2).Value = Hex(ThisWorkbook.Colors(Ndx))
Cells(Ndx, 3).Value = Ndx
Next Ndx
End Sub


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 13:01:02 -0700, clara
wrote:

Hi all,

Is there a table render the colorindex and color?

Clara