Private Sub EuroRon(ByRef Monnaie As String)
Dim f As Worksheet
Set f = Worksheets(ActiveSheet.Name)
Dim Devise As Double
Range("E1") = Monnaie
Devise = Range("J2").Value
Dim r, c As Range
Set r = f.Range(f.Cells(6, 4), f.Cells(f.Cells(65536, 2).End(xlUp).Row, 16))
On Error Resume Next
For Each c In r
If Not c.HasFormula = True And c.Value <> Empty Then
[S]'c.Value = IIf(f.Range("E1").Value = "EURO", c.Value / Devise, c.Value * Devise)[/S]
c.Value = IIf(f.Range("E1").Value = "EURO", c.Value * Devise, c.Value / Devise)
End If
Next c
On Error GoTo 0
MsgBox Int((Timer - t) * 1000) & " ms"
End Sub