Function ListeSansVides(champ As Range, Optional fmt As String)
Application.Volatile
temp = champ.Value
Dim b()
ReDim b(1 To Application.Caller.Rows.Count)
n = 0
For Each c In temp
If c <> "" Then
n = n + 1
If IsMissing(fmt) Then
b(n) = c
Else
b(n) = format(c, fmt)
End If
End If
Next
ListeSansVides = Application.Transpose(b)
End Function