VBA for color index 192

[shiva_reshs]

Hi,

128 is VBA color index code for dark red. I know Index 9, but 192 is slight different red.

How can I fit that into below VBA?

Please Login or Register  to view this content.

When I change to 192, I get below error msg

Run-Time error '9':
Subscript out of Range.

Regards,

[nilem]

maybe ....Interior.Color = 192

[shiva_reshs]

nice..

and how to add or make font color changes to white in the same cell??

Regards,

[Andy Pope]

128 is RGB code for a shade of Red

Please Login or Register  to view this content.

ColorIndex values are 0 to 57 are maps to the old colour pallete in xl2003.

[shiva_reshs]

oh.. got it

Thanks!!

[nilem]

.....Font.Color = vbWhite

[shiva_reshs]

Thanks a ton..

Reps added.
Regards

[JOHN H. DAVIS]

You can use the index for the font.

Please Login or Register  to view this content.

[shiva_reshs]

Thanks John!

Regards,