Is there a mathematical function/equation that will find the complementary color of a given hex color code (i.e. 000000 for black, FF0000 for red, etc) <P>So if I input 000000, I'll get FFFFFF back.

This function allows you to convert VBA colour codes from 1 to 56 (Interior.ColorIndex) to their long value (Interior.Color): Function CouversionCouleurLong(Couleur As Integer) As Long ...