Bonjour,
J'aimerai savoir comment on compte le nombre de valeur dans différente colonne puis aprés affecter ce nombre dans un texte!
J'aimerai savoir comment on compte le nombre de valeur dans différente colonne puis aprés affecter ce nombre dans un texte!
Code:
Sub cell_text_vert()
Dim plage As Range
Dim cel As Range
Dim n As Long
Set plage = Sheets("CONTROLE").Range("B12:G" & [G61000].End(xlDown).Row)
Set F = Sheets("CONTROLE").Range("F12:F" & [F1000].End(xlDown).Row)
Set G = Sheets("CONTROLE").Range("G12:G" & [G1000].End(xlDown).Row)
Set H = Sheets("CONTROLE").Range("H12:H" & [H1000].End(xlDown).Row)
Set i = Sheets("CONTROLE").Range("I12:I" & [I1000].End(xlDown).Row)
Set j = Sheets("CONTROLE").Range("J12:J" & [J1000].End(xlDown).Row)
Set K = Sheets("CONTROLE").Range("K12:K" & [K1000].End(xlDown).Row)
Set L = Sheets("CONTROLE").Range("L12:L" & [L1000].End(xlDown).Row)
Set M = Sheets("CONTROLE").Range("M12:M" & [M1000].End(xlDown).Row)
Set NN = Sheets("CONTROLE").Range("N12:N" & [N1000].End(xlDown).Row)
Set O = Sheets("CONTROLE").Range("O12:O" & [O1000].End(xlDown).Row)
Set P = Sheets("CONTROLE").Range("P12:P" & [P1000].End(xlDown).Row)
Set Q = Sheets("CONTROLE").Range("Q12:Q" & [Q1000].End(xlDown).Row)
Set R = Sheets("CONTROLE").Range("R12:R" & [R1000].End(xlDown).Row)
Set S = Sheets("CONTROLE").Range("S12:S" & [S1000].End(xlDown).Row)
n = 0
For Each cel In plage
If cel <> 0 Then
n = n + 1 'compteur
End If
Next
With Sheets("CONTROLE")
.Range("A1") = "Il y a " & n & " cellules"
End With
n = 0
For Each cel In plage
If cel <> 0 Then
n = n + 1 'compteur
End If
Next
With Sheets("CONTROLE")
.Range("A2") = "Il y a " & n & " cellules"
End With
n = 0
For Each cel In F
If cel <> 0 Then
n = n + 1 'compteur
End If
Next
With Sheets("CONTROLE")
.Range("A3") = "Il y a " & n & " cellules"
End With
n = 0
For Each cel In G
If cel <> 0 Then
n = n + 1 'compteur
End If
Next
With Sheets("CONTROLE")
.Range("A4") = "Il y a " & n & " cellules"
End With
end sub