Interior.ColorIndex

[matrixknow]

I know you have a limited number of VB Constants like vbBlue.How can I find a method or list to find the corresponding number for a certain color. eg. I look for light gray.

 

[SkipVought]

Hi,

Please post VBA questions in Forum707

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}