Hey Bob!

Does that mean that I can define only upto a maximum number of 56 colors?

Thanx Again
--
Best Regards,

FARAZ A. QURESHI


"Bob Phillips" wrote:


ActiveWorkbook.Colors(15) = RGB(211, 211, 211)
Activecell.interior.colorindex = 15

For i = 1 To 56

Cells(i, "A").Interior.Colorindex = i
Cells(i, "B").Value = i
Next i


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"FARAZ QURESHI" wrote in message
...
Can you apply a self-defined custom color (an RGB Combination) 2 cell(s)
via
a macro? If yes, kindly provide a sample.

How can I get a list of color index of pre-defined colors for their
application on cell(s)?

Thanx!