List excel color values

Rate this article

Loading ...

April 1st, 2008 by

daniva

Print This Post

Google Search Results

You arrived here after searching for the following phrases:

QTP
code
interior
color
index
Excel

Click a phrase to jump to the first occurrence, or return to the search results.

Demonstration script that displays the various colors — and their related color index — available when programmatically controlling Microsoft Excel

Set excel = CreateObject( "Excel.Application" )With excel   .Visible = True   .Workbooks.Add   For i = 1 to 56      .Cells( i, 1 ).Value = i      .Cells( i, 1 ).Interior.ColorIndex = i   NextEnd With

Was this article useful? Rate it!

Posted in MS-Excel

2 Responses to “List excel color values”

kalluri.sm Says:
May 2nd, 2008 at 11:35 am
[+]
fine... ...
[Open ↓]

[-]
fine

[Close ↑]
Manish_Bhalshankar Says:
August 26th, 2008 at 7:11 am
[+]
Yes it works!!! But insteas of printing the index, is there any way to display the hexadecimal color code?... ...
[Open ↓]

[-]
Yes it works!!! But insteas of printing the index, is there any way to display the hexadecimal color code?

[Close ↑]