Bonjour

comment créer une fonction pour afficher le minimum d'une serie sans tenir compte des valeurs nulles?

cordialement

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
 
Function minimumquinze(st1 As Range, st2 As Range, st3 As Range, st4 As Range, st5 As Range, st6 As Range, st7 As Range, st8 As Range, st9 As Range, st10 As Range, st11 As Range, st12 As Range, st13 As Range, st14 As Range, st15 As Range) As Variant
Application.Volatile
 
minimum = Application.WorksheetFunction.Min(st1, st2, st3, st4, st5, st6, st7, st8, st9, st10, st11, st12, st13, st14, st15)
 
minimumquinze = minimum
 
End Function