nbM = nbval(MOAD)
liges = lignes(MOAD)
MsgBox (nbM)
MsgBox (liges)
Sub rrr()
nb = Application.WorksheetFunction.CountA([MOAD])
liges = Range("MOAD").Rows.Count
MsgBox nb
MsgBox liges
End Sub
Cells(1000, 230).Select
Selection.FormulaR1C1 = "=NBVAL(MOAD)"
nbM = Selection.Value
Cells(5, 1).Value = nbM
liges = Range("MOAD").Rows.Count
Application.WorksheetFunction.CountA([MOAD])
Une autre idée vers laquelle creuser ?
Function MOAD(ByVal n As Range)
vCell = n.Value
Select Case vCell
Case "DD"
vCell = "D.Dewevre"
Case "JB"
vCell = "JB.Combebias"
Case "TP"
vCell = "T.Parisot"
Case "PL"
vCell = "P.Loic"
Case "DM"
Case Else
vCell = ""
End Select
toto = vCell
End Function