Phillip,

Well, almost everything.
Forgot to mention Chip's site too

John

John Wilson wrote:

Phillip,

Just about everything you wanted to know about colors:
http://www.mvps.org/dmcritchie/excel/colors.htm

John

Philip Reece-Heal wrote:

mycolor = ActiveCell.Offset(0, 1).Interior.Color
ActiveCell.Value = mycolor

The above code gives me the integer color values (which I don't understand)
for the cell to the right of the active cell and the following code gives me
the color palette numbers:

mycolor = ActiveCell.Offset(0, 1).Interior.ColorIndex
ActiveCell.Value = mycolor

How can I get the RGB color values

Any info gratefully appreciated

Philip