moi j'avais fait un truc comme ca, mais je ne sais pas comment faire pour lui dire de ne pas calculer si cellule vide et l'intégrer dans cette macro
y = Sheets("Balance").Range("A1").End(xlDown).Row
For x = 2 To y
If Sheets("Balance").Cells(x, 5) = "P&L" Then
Select Case Sheets("Balance").Cells(x, 1)
Case "330", "335", "533", "562"
Sheets("Balance").Cells(x, 22) = "=U" & x & "/'[devises.xlsx]2017'!$N$5"
Case "360"
Sheets("Balance").Cells(x, 22) = "=U" & x & "/'[devises.xlsx]2017'!$N$12"
Case "430"
Sheets("Balance").Cells(x, 22) = "=U" & x & "/'[devises.xlsx]2017'!$N$6"
Case "460", "465", "536"
Sheets("Balance").Cells(x, 22) = "=U" & x & "/'[devises.xlsx]2017'!$N$8"
Case "500"
Sheets("Balance").Cells(x, 22) = "=U" & x & "/'[devises.xlsx]2017'!$N$10"
Case "540"
Sheets("Balance").Cells(x, 22) = "=U" & x & "/'[devises.xlsx]2017'!$N$9"
Case "566"
Sheets("Balance").Cells(x, 22) = "=U" & x & "/'[devises.xlsx]2017'!$N$15"
Case "580"
Sheets("Balance").Cells(x, 22) = "=U" & x & "/'[devises.xlsx]2017'!$N$14"
Case Else
Sheets("Balance").Cells(x, 22) = "=U" & x & " "
End Select
End If
Next x