color code transparency for interior.color

[velocity]

Does anyone know the vba color code for transparency to fill a cell.

this is the code I have

If c.Value < 99999 Then
Range(c, c.Offset(0, 3)).Interior.Color = &HFFFFFF
End If


&HFFFFFF = White

If there is not a code for transparency, does anyone know a work around?

thanks

 

[MrKowz]

I think you're looking for Range(c, c.Offset(0,3)).Interior.ColorIndex = 0

 

[velocity]

That did it. Thanks