Expressing Color in this format &H80000001

[hmk]

Hi there

--------------------------------------------------------------------------------
Selection.Interior.ColorIndex = 36 
    Selection.Interior.ColorIndex = 35 
    Selection.Interior.ColorIndex = 37 
    Selection.Interior.ColorIndex = 38 
    Selection.Interior.ColorIndex = xlNone

How to express these color in this format (&H80000001) in the code ?

 

[GlennUK]

Look at the HEX function. By the way you can use &Hnn numbers directly in code, although your number in decimal ( -2147483647 ) doesn't match a colour code as far as I know.