1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| Dim Localvac As Long
Dim Localnonvac As Long
Dim Reponse As Integer
Message = "Cellules vides"
If ville = "Marzy" Then
Localvac = WorksheetFunction.CountIfs(plage1, "oui", plage2, "Marzy")
Localnonvac = WorksheetFunction.CountIfs(plage1, "non", plage2, "Marzy")
Else
Localvac = Application.WorksheetFunction.CountIfs(plage1, "oui", plage2, "Nevers")
Localnonvac = Application.WorksheetFunction.CountIfs(plage1, "non", plage2, "Nevers")
End If
On Error GoTo Erreur
PourcLocVac = Localvac / (Localvac + Localnonvac)
Exit Function
Erreur:
MsgBox (Message)
If Reponse = vbOKOnly Then 'Car VbOKOnly a la valeur d'un entier, du coup il est integer
PourcLocVac = 0
End If
End Function
Sub Poucentage()
Dim plage1 As Range
Dim plage2 As Range
Sheets("Feuil1").Select
Set plage1 = Range("b2", Range("b1048576").End(xlUp))
Set plage2 = Range("c2", Range("b1048576").End(xlUp))
Sheets("Feuil2").Select
Range("D2").Value = "Marzy"
Range("D3").Value = PourcLocVac(plage1, plage2, "Marzy")
Range("E2").Value = "Nevers"
Range("E3").Value = PourcLocVac(plage1, plage2, "Nevers")
End Sub |
Partager