Thread: color codes
View Single Post
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi Wazooli

Run this macro on a empty sheet


Sub ListColors()
Dim a As Long
For a = 1 To 56
Cells(a, 1).Interior.ColorIndex = a
Cells(a, 2).Value = a
Next a
End Sub


More info you can find here
http://www.mvps.org/dmcritchie/excel/colors.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Wazooli" wrote in message
...
After seeing many posts regarding extracting the color value of a cell, I
am
wondering where one can get a listing of default colors with their
respective
codes.