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 Dim CouleursLng ...