Option Explicit
Function NO_COULEUR(ByVal Rng As Range) As Variant()
CalcNo_Couleur NO_COULEUR, Rng
End Function
Sub CalcNo_Couleur(T(), ByVal Rng As Range)
Dim L&, C&
ReDim T(1 To Rng.Rows.Count, 1 To Rng.Columns.Count)
For L = 1 To UBound(T, 1): For C = 1 To UBound(T, 2)
T(L, C) = Rng(L, C).Interior.Color
Next C, L
End Sub